Date & Time Functions
This section provides reference information for the datetime-related functions in Databend.
Conversion Functions
- DATE
- TO_MONTH
- MONTH
- TO_DATE
- TO_DATETIME
- TODAY
- TO_DAY_OF_MONTH
- DAY
- TO_DAY_OF_WEEK
- TO_DAY_OF_YEAR
- TO_HOUR
- TO_MINUTE
- TO_MONDAY
- TOMORROW
- TO_QUARTER
- QUARTER
- TO_SECOND
- TO_START_OF_DAY
- TO_START_OF_FIFTEEN_MINUTES
- TO_START_OF_FIVE_MINUTES
- TO_START_OF_HOUR
- TO_START_OF_ISO_YEAR
- TO_START_OF_MINUTE
- TO_START_OF_MONTH
- TO_START_OF_QUARTER
- TO_START_OF_SECOND
- TO_START_OF_TENMINUTES
- TO_START_OF_WEEK
- TO_START_OF_YEAR
- TO_TIMESTAMP
- TO_UNIX_TIMESTAMP
- TO_WEEK_OF_YEAR
- WEEK
- WEEKOFYEAR
- TO_YEAR
- YEAR
- TO_YYYYMM
- TO_YYYYMMDD
- TO_YYYYMMDDHH
- TO_YYYYMMDDHHMMSS