The following functions are available.

Function Name Arguments Description Example
Now Now([timezone]) Returns the date and time type for the current date and time.
Year Year(t[, timezone]) Returns the year of date and time type t. If timezone is specified, it is interpreted as the time zone.
Month Month(t[, timezone]) Returns the month of date and time type t. If timezone is specified, it is interpreted as the time zone.
Day Day(t[, timezone]) Returns a day of type t. If timezone is specified, it is interpreted as the time zone.
Hour Hour(t[, timezone]) Return the time of date and time type t. If timezone is specified, it is interpreted as the time zone.
Minute Minute(t[, timezone]) Return the minutes of date and time type t. If timezone is specified, it is interpreted as the time zone.
Second Second(t[, timezone]) Return seconds of date and time type t. If timezone is specified, it is interpreted as the time zone.
Weekday Weekday(t[, timezone]) Return the day of the week for date and time type t. If timezone is specified, it is interpreted as the time zone. (0 is Sunday.)
ToLocal ToLocal(t) Convert date and time type t to system time zone
ToUTC ToUTC(t) Convert date and time type t to UTC
ToTimezone ToTimezone(t, timezone) Converts a date and time type t to a specified time zone ToTimezone(Now(), “America/New_York”)
DateFormat DateFormat(t, layout) Convert a date and time type t to a string with the specified layout DateFormat(Now(), “02 Jan 06 15:04 MST”)
DateParse DateParse(layout, s[, timezone]) Interprets s along the layout and returns a date/time type

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.