The now Function
The 'now' function returns the date and time in the resource time zone.
You can configure the function according to the format
given in this table:
Format Character | Description | Example |
---|---|---|
d | Day of the month, 2 digits | 1 to 31 |
dd | Day of the month, 2 digits, with leading zeros | 01 to 31 |
H | 24-hour format of an hour | 0 through 23 |
h | 12-hour format of an hour | 1 through 12 |
HH | 24-hour format of an hour, with leading zeros | 00 through 23 |
hh | 12-hour format of an hour, with leading zeros | 01 through 12 |
M | Numeric representation of a month | 1 through 12 |
m | Minutes | 0 to 59 |
MM | Numeric representation of a month, with leading zeros | 01 through 12 |
mm | Minutes, with leading zeros | 00 to 59 |
s | Seconds | 0 through 59 |
ss | Seconds, with leading zeros | 00 through 59 |
t | Short uppercase Ante meridiem and Post meridiem | A or P |
tt | Uppercase Ante meridiem and Post meridiem | AM or PM |
yy | A two digit representation of a year, with leading zeros | 17 |
yyyy | A full numeric representation of a year, 4 digits | 2017 |
z | The time zone offset | +0 to ±11 |
zz | The time zone offset, with a leading zero | +00 to ±11 |
zzz | The full timezone offset, with a leading zero | +00:00 to ±11:30 |