# Date and Time Functions

```{toctree}
:maxdepth: 1
:titlesonly:

CONVERT_TZ() <convert-tz>
CURDATE() <curdate>
CURRENT_TIMESTAMP() <current-timestamp>
DATE() <date>
DATE_ADD() <date-add>
DATE_FORMAT() <date-format>
DATE_SUB() <date-sub>
DATEDIFF() <datediff>
DAY() <day>
DAYOFYEAR() <dayofyear>
EXTRACT() <extract>
HOUR() <hour>
FROM_UNIXTIME <from-unixtime>
MINUTE() <minute>
MONTH() <month>
NOW() <now>
SECOND() <second>
STR_TO_DATE() <str-to-date>
SYSDATE() <sysdate>
TIME() <time>
TIMEDIFF() <timediff>
TIMESTAMP() <timestamp>
TIMESTAMPDIFF() <timestampdiff>
TO_DATE() <to-date>
TO_DAYS() <to-days>
TO_SECONDS() <to-seconds>
UNIX_TIMESTAMP <unix-timestamp>
UTC_TIMESTAMP() <utc-timestamp>
WEEK() <week>
WEEKDAY() <weekday>
YEAR() <year>
```