Date & Time Functions

Truncates a date, time, or timestamp value to a specified precision. For example, if you truncate 2022-07-07 to MONTH, the result will be 2022-07-01; if you truncate 2022-07-07 0101.123456 to SECOND, the result will be 2022-07-07 0101.000000.

📄️ 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.

📄️ toStartOfSecond

Rounds down a date with time to the start of the second.

📄️ 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