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.
Date and Time Functions
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