日期和时间函数

📄️ DATE_ADD

Adds the time interval or date interval to the provided date or date with time (timestamp/datetime).

📄️ DATE_SUB

Subtracts the time interval or date interval from the provided date or date with time (timestamp/datetime).

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

📄️ TIME_SLOT

Rounds the time to the half hour.

📄️ TIMEZONE

Returns the timezone for the current connection.

📄️ TO_MONTH

Converts a date or date with time (timestamp/datetime) to a UInt8 number containing the month number (1-12).

📄️ TO_DATE

Converts the input expression to a date.

📄️ TO_DATETIME

TODATETIME is an alias of TOTIMESTAMP. See TO_TIMESTAMP.

📄️ TODAY

Returns current date.

📄️ TO_DAY_OF_MONTH

Converts a date or date with time (timestamp/datetime) to a UInt8 number containing the number of the day of the month (1-31).

📄️ TO_DAY_OF_WEEK

Converts a date or date with time (timestamp/datetime) to a UInt8 number containing the number of the day of the week (Monday is 1, and Sunday is 7).

📄️ TO_DAY_OF_YEAR

Converts a date or date with time (timestamp/datetime) to a UInt16 number containing the number of the day of the year (1-366).

📄️ TO_HOUR

Converts a date with time (timestamp/datetime) to a UInt8 number containing the number of the hour in 24-hour time (0-23). This function assumes that if clocks are moved ahead, it is by one hour and occurs at 2 a.m., and if clocks are moved back, it is by one hour and occurs at 3 a.m. (which is not always true – even in Moscow the clocks were twice changed at a different time).

📄️ TO_MINUTE

Converts a date with time (timestamp/datetime) to a UInt8 number containing the number of the minute of the hour (0-59).

📄️ TO_MONDAY

Rounds down a date or date with time (timestamp/datetime) to the nearest Monday. Returns the date.

📄️ TOMORROW

Returns tomorrow date, same as today() + 1.

📄️ TO_SECOND

Converts a date with time (timestamp/datetime) to a UInt8 number containing the number of the second in the minute (0-59).

📄️ TO_START_OF_DAY

Rounds down a date with time (timestamp/datetime) to the start of the day.

📄️ TO_START_OF_FIFTEEN_MINUTES

Rounds down the date with time (timestamp/datetime) to the start of the fifteen-minute interval.

📄️ TO_START_OF_FIVE_MINUTES

Rounds down a date with time (timestamp/datetime) to the start of the five-minute interval.

📄️ TO_START_OF_HOUR

Rounds down a date with time (timestamp/datetime) to the start of the hour.

📄️ TO_START_OF_ISO_YEAR

Returns the first day of the ISO year for a date or a date with time (timestamp/datetime).

📄️ TO_START_OF_MINUTE

Rounds down a date with time (timestamp/datetime) to the start of the minute.

📄️ TO_START_OF_MONTH

Rounds down a date or date with time (timestamp/datetime) to the first day of the month. Returns the date.

📄️ TO_START_OF_QUARTER

Rounds down a date or date with time (timestamp/datetime) to the first day of the quarter. The first day of the quarter is either 1 January, 1 April, 1 July, or 1 October. Returns the date.

📄️ TO_START_OF_SECOND

Rounds down a date with time (timestamp/datetime) to the start of the second.

📄️ TO_START_OF_TEN_MINUTES

Rounds down a date with time (timestamp/datetime) to the start of the ten-minute interval.

📄️ TO_START_OF_WEEK

Returns the first day of the week for a date or a date with time (timestamp/datetime). The first day of a week can be Sunday or Monday, which is specified by the argument mode.

📄️ TO_START_OF_YEAR

Returns the first day of the year for a date or a date with time (timestamp/datetime).

📄️ TO_TIMESTAMP

Converts the input expression to a date with time (timestamp/datetime).

📄️ TO_YEAR

Converts a date or date with time (timestamp/datetime) to a UInt16 number containing the year number (AD).

📄️ TO_YYYYMM

Converts a date or date with time (timestamp/datetime) to a UInt32 number containing the year and month number.

📄️ TO_YYYYMMDD

Converts a date or date with time (timestamp/datetime) to a UInt32 number containing the year and month number (YYYY 10000 + MM 100 + DD).

📄️ TO_YYYYMMDDHHMMSS

Converts a date or date with time (timestamp/datetime) 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.