Date and Time
Date, time and duration are a set of virtual data types, which are internally represented as numbers using unix timestamps (numbers).
Operators
Refer to a full list of number operators.
Functions
date
Accepts a formatted string as an input and returns a unix timestamp in seconds.
Syntax
date('now');
date('yesterday');
date('2022-01-01');
date('2022-01-01 16:00');
date('2022-04-04T21:48:30Z');
time
Accepts a formatted string as an input and returns a number representing seconds from midnight.
Syntax
time('21:49');
time('21:48:20');
time('2022-04-04T21:48:30Z'); // extracts time from date string
duration
Accepts a formatted string (from seconds up to hour) as an input and returns duration in seconds.
Syntax
duration('1h'); // 3600
duration('30m'); // 1800
duration('10h'); // 36000
dayOfWeek
Accepts a unix timestamp and returns the day of the week as a number.
Syntax
dayOfWeek(date('2022-11-08')); // 2
dayOfMonth
Accepts a unix timestamp and returns the day of the month as a number.
Syntax
dayOfMonth(date('2022-11-09')); // 9
dayOfYear
Accepts a unix timestamp and returns the day of the year as a number.
Syntax
dayOfYear(date('2022-11-10')); // 314
weekOfMonth
Accepts a unix timestamp and returns the week of the month as a number.
Syntax
weekOfMonth(date('2022-11-11')); // 2
weekOfYear
Accepts a unix timestamp and returns the week of the year as a number.
Syntax
weekOfYear(date('2022-11-12')); // 45
seasonOfYear
Accepts a unix timestamp and returns the seasons of the year as a string.
Syntax
seasonOfYear(date('2022-11-13')); // Autumn
monthString
Accepts a unix timestamp and returns the month of the year as a string.
Syntax
monthString(date('2022-11-14')); // Nov
weekdayString
Accepts a unix timestamp and returns the day of the week as a string.
Syntax
weekdayString(date('2022-11-14')); // Mon
startOf
Accepts a unix timestamp and a unit. Returns the start of date based on specified unit.
Allowed units:
| Unit | Argument to be passed |
|---|---|
| Second | "s" | "second" | "seconds" |
| Minute | "m" | "minute" | "minutes" |
| Hour | "h" | "hour" | "hours" |
| Day | "d" | "day" | "days" |
| Week | "w" | "week" | "weeks" |
| Month | "M" | "month" | "months" |
| Year | "y" | "year" | "years" |
Syntax
startOf(date('2022-11-14 15:45:12'), 'day'); // 2022-11-14 00:00:00
endOf
Accepts a unix timestamp and a unit. Returns the end of date based on specified unit.
Syntax
endOf(date('2022-11-14 15:45:12', 'day')); // 2022-11-14 23:59:59
Updated 3 days ago