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 |