# Date and time functions
<a name="date-time-functions-spark"></a>

Date and time functions allow you to perform a wide range of operations on date and time data, such as extracting parts of a date, performing date calculations, formatting dates and times, and working with the current date and time. These functions are essential for tasks such as data analysis, reporting, and data manipulation involving temporal data.

AWS Clean Rooms supports the following date and time functions:

**Topics**
+ [ADD\_MONTHS function](ADD_MONTHS.md)
+ [CONVERT\_TIMEZONE function](s_CONVERT_TIMEZONE.md)
+ [CURRENT\_DATE function](CURRENT_DATE_function.md)
+ [CURRENT\_TIMESTAMP function](CURRENT_TIMESTAMP.md)
+ [DATE\_ADD function](DATE_ADD_function.md)
+ [DATE\_DIFF function](DATE_DIFF_function.md)
+ [DATE\_PART function](DATE_PART_function.md)
+ [DATE\_TRUNC function](DATE_TRUNC.md)
+ [DAY function](DAY.md)
+ [DAYOFMONTH function](DAYOFMONTH.md)
+ [DAYOFWEEK function](DAYOFWEEK.md)
+ [DAYOFYEAR function](DAYOFYEAR.md)
+ [EXTRACT function](EXTRACT_function.md)
+ [FROM\_UTC\_TIMESTAMP function](FROM_UTC_TIMESTAMP.md)
+ [HOUR function](HOUR.md)
+ [MINUTE function](MINUTE.md)
+ [MONTH function](MONTH.md)
+ [SECOND function](SECOND.md)
+ [TIMESTAMP function](TIMESTAMP.md)
+ [TO\_TIMESTAMP function](TO_TIMESTAMP.md)
+ [YEAR function](YEAR.md)
+ [Date parts for date or timestamp functions](Dateparts_for_datetime_functions.md)