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