Date and Time Functions
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
In this section
- ADDTIME
- CONVERT_TZ
- CURRENT_DATE And CURDATE
- CURRENT_TIME And CURTIME
- CURRENT_TIMESTAMP
- DATE
- DATEDIFF
- DATE_ADD
- DATE_FORMAT
- DATE_SUB
- DATE_TRUNC
- DAY
- DAYNAME
- DAYOFWEEK
- DAYOFYEAR
- EXTRACT
- FROM_DAYS
- FROM_UNIXTIME
- GET_FORMAT
- HOUR
- LAST_DAY
- LOCALTIMESTAMP
- MICROSECOND
- MINUTE
- MONTH
- MONTHNAME
- MONTHS_BETWEEN
- NOW
- QUARTER
- SECOND
- SEC_TO_TIME
- STR_TO_DATE
- TIME
- TIMEDIFF
- TIMESTAMP
- TIMESTAMPADD
- TIMESTAMPDIFF
- TIME_FORMAT
- TIME_TO_SEC
- TO_CHAR
- TO_DATE
- TO_DAYS
- TO_SECONDS
- TO_TIMESTAMP
- TRUNC
- UNIX_TIMESTAMP
- UTC_DATE
- UTC_TIME
- UTC_TIMESTAMP
- WEEK
- WEEKDAY
- YEAR
Last modified: November 17, 2022