# Date and Time Functions

## In this section

* [ADDTIME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/addtime.md)
* [CONVERT\_TZ](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/convert-tz.md)
* [CURRENT\_DATE And CURDATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/current-date-and-curdate.md)
* [CURRENT\_TIME And CURTIME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/current-time-and-curtime.md)
* [CURRENT\_TIMESTAMP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/current-timestamp.md)
* [DATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/date.md)
* [DATEDIFF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/datediff.md)
* [DATE\_ADD](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/date-add.md)
* [DATE\_FORMAT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/date-format.md)
* [DATE\_SUB](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/date-sub.md)
* [DATE\_TRUNC](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/date-trunc.md)
* [DAY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/day.md)
* [DAYNAME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/dayname.md)
* [DAYOFWEEK](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/dayofweek.md)
* [DAYOFYEAR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/dayofyear.md)
* [EXTRACT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/extract.md)
* [FROM\_DAYS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/from-days.md)
* [FROM\_UNIXTIME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/from-unixtime.md)
* [GET\_FORMAT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/get-format.md)
* [HOUR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/hour.md)
* [LAST\_DAY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/last-day.md)
* [LOCALTIMESTAMP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/localtimestamp.md)
* [MICROSECOND](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/microsecond.md)
* [MINUTE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/minute.md)
* [MONTH](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/month.md)
* [MONTHNAME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/monthname.md)
* [MONTHS\_BETWEEN](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/months-between.md)
* [NOW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/now.md)
* [QUARTER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/quarter.md)
* [SECOND](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/second.md)
* [SEC\_TO\_TIME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/sec-to-time.md)
* [STR\_TO\_DATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/str-to-date.md)
* [TIME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/time.md)
* [TIMEDIFF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/timediff.md)
* [TIMESTAMP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/timestamp.md)
* [TIMESTAMPADD](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/timestampadd.md)
* [TIMESTAMPDIFF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/timestampdiff.md)
* [TIME\_FORMAT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/time-format.md)
* [TIME\_TO\_SEC](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/time-to-sec.md)
* [TO\_CHAR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/to-char.md)
* [TO\_DATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/to-date.md)
* [TO\_DAYS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/to-days.md)
* [TO\_SECONDS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/to-seconds.md)
* [TO\_TIMESTAMP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/to-timestamp.md)
* [TRUNC](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/trunc.md)
* [UNIX\_TIMESTAMP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/unix-timestamp.md)
* [UTC\_DATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/utc-date.md)
* [UTC\_TIME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/utc-time.md)
* [UTC\_TIMESTAMP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/utc-timestamp.md)
* [WEEK](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/week.md)
* [WEEKDAY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/weekday.md)
* [YEAR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/year.md)

***

Modified at: November 17, 2022

Source: [/db/v9.1/reference/sql-reference/date-and-time-functions/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/)

(An index of the documentation is available at /llms.txt)