📄️ Add time interval
Add time interval function
Datetime Functions
📄️ NOW
Returns the current date and time.
📄️ Subtract time interval
Subtract time interval function
📄️ timeslot
Rounds the time to the half hour.
📄️ toMonth
Converts a date or date with time to a UInt8 number containing the month number (1-12).
📄️ TODAY
Returns current date.
📄️ TODAYOFMONTH
Converts a date or date with time to a UInt8 number containing the number of the day of the month (1-31).
📄️ toDayOfWeek
Converts a date or date with time to a UInt8 number containing the number of the day of the week (Monday is 1, and Sunday is 7).
📄️ toDayOfYear
Converts a date or date with time to a UInt16 number containing the number of the day of the year (1-366).
📄️ toHour
Converts a date with time to a UInt8 number containing the number of the hour in 24-hour time (0-23).
📄️ toMinute
Converts a date with time to a UInt8 number containing the number of the minute of the hour (0-59).
📄️ toMonday
Rounds down a date or date with time to the nearest Monday.
📄️ TOMORROW
Returns tomorrow date, same as today() + 1.
📄️ toSecond
Converts a date with time to a UInt8 number containing the number of the second in the minute (0-59).
📄️ toStartOfDay
Rounds down a date with time to the start of the day.
📄️ toStartOfFifteenMinutes
Rounds down the date with time to the start of the fifteen-minute interval.
📄️ toStartOfFiveMinutes
Rounds down a date with time to the start of the five-minute interval.
📄️ toStartOfHour
Rounds down a date with time to the start of the hour.
📄️ toStartOfISOYear
Returns the first day of the ISO year for a date or a date with time.
📄️ toStartOfMinute
Rounds down a date with time to the start of the minute.
📄️ toStartOfMonth
Rounds down a date or date with time to the first day of the month.
📄️ toStartOfQuarter
Rounds down a date or date with time to the first day of the quarter.
📄️ toStartOfTenMinutes
Rounds down a date with time to the start of the ten-minute interval.
📄️ toStartOfWeek
Returns the first day of the year for a date or a date with time.
📄️ toStartOfYear
Returns the first day of the year for a date or a date with time.
📄️ TOYEAR
Converts a date or date with time to a UInt16 number containing the year number (AD).
📄️ toYYYYMM
Converts a date or date with time to a UInt32 number containing the year and month number.
📄️ toYYYYMMDD
Converts a date or date with time to a UInt32 number containing the year and month number (YYYY 10000 + MM 100 + DD).
📄️ toYYYYMMDDhhmmss
Converts a date or date with time to a UInt64 number containing the year and month number (YYYY 10000000000 + MM 100000000 + DD 1000000 + hh 10000 + mm * 100 + ss).
📄️ YESTERDAY
Returns yesterday date, same as today() - 1.