# 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\$1MONTHS function](ADD_MONTHS.md)
+ [CONVERT\$1TIMEZONE function](s_CONVERT_TIMEZONE.md)
+ [CURRENT\$1DATE function](CURRENT_DATE_function.md)
+ [CURRENT\$1TIMESTAMP function](CURRENT_TIMESTAMP.md)
+ [DATE\$1ADD function](DATE_ADD_function.md)
+ [DATE\$1DIFF function](DATE_DIFF_function.md)
+ [DATE\$1PART function](DATE_PART_function.md)
+ [DATE\$1TRUNC 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\$1UTC\$1TIMESTAMP 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\$1TIMESTAMP function](TO_TIMESTAMP.md)
+ [YEAR function](YEAR.md)
+ [Date parts for date or timestamp functions](Dateparts_for_datetime_functions.md)