Datetime Functions

Add time interval to a date or datetime, return the result of date or datetime type.

Returns the current date and time.

Subtract time interval from a date or datetime, return the result of date or datetime type.

Returns current date.

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

Returns the first day of the ISO year for a date or a date with time.

Returns the first day of the year for a date or a date with time.

Converts a date or date with time to a UInt32 number containing the year and month number.

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

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).

Returns yesterday date, same as today() - 1.