Date templates are used to manipulate dates and datetime fields.
Template name | Template format | Return type |
current day | current day | integer |
current hour | current hour | integer |
current millisecond | current millisecond | integer |
current minute | current minute | integer |
current month | current month | integer |
current second | current second | integer |
current year | current year | integer |
day from | day from <date or datetime> |
integer |
day of the month from | day of the month from <date or datetime> |
integer |
day of the week from | day of the week from <date or datetime> |
integer |
day of the year from | day of the year from <date or datetime> |
integer |
days between | days between <date or datetime> and <date or datetime> |
integer |
weekdays between | weekdays between <date or datetime> and <date or datetime> |
integer |
get local datetime from | get local datetime from <datetime> |
datetime value having a local kind |
get unspecified datetime from |
get unspecified datetime from <datetime> |
datetime value having a unspecified kind |
get UTC datetime from | get UTC datetime from <datetime> |
datetime value having a UTC kind |
hours from | hour from < datetime> | integer |
hours between | hours between <datetime> and <datetime> |
integer |
millisecond from | millisecond from <datetime> |
integer |
milliseconds between | milliseconds between <datetime> and <datetime> |
integer |
minute from | minute from < datetime> | integer |
minutes between | minutes between <datetime> and <datetime> |
integer |
month from | month from <date or datetime> |
integer |
months between | months between <date or datetime> and <date or datetime> |
integer |
now | now | datetime |
number of days in the month from |
number of days in the month from <date> |
integer |
number of days in the year from |
number of days in the year from |
integer |
second from | second from < datetime> | integer |
seconds between | seconds between <datetime> and |
integer |
<datetime> | ||
today | today | date |
tommorrow | tommorrow | date |
year from | year from <date> | integer |
years between | years between <date> and <date> |
integer |
yesterday | yesterday | date |
is a leap year | <datetime> is a leap year | Boolean |
is a local datetime | <datetime> is a local datetime |
Boolean |
is a week day | <datetime> is a week day | Boolean |
is an unspecified datetime | <datetime> is an unspecified datetime |
Boolean |
is an UTC datetime | <datetime> is an UTC datetime |
Boolean |
is on a week end | <datetime> is on a week end |
Boolean |
minus | <datetime> minus <timespan> |
|
plus | <datetime> plus <timespan> |
|
plus | <date or datetime> plus <integer> weekdays |
date or datetime |
is a date | <text> is a date | Boolean |
is a datetime | <text> is a datetime | Boolean |
Comments
0 comments
Please sign in to leave a comment.