# Date and Time

- [DATE](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/date.md): Creates a date based on the provided year, month, and day values
- [DATE\_DIFF](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/date_diff.md): Calculates the difference in days, weeks, months, quarters, or years between two dates
- [DATETIME](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/datetime.md): Creates a datetime based on the provided year, month, day, hour, minute, and second values
- [DAY](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/day.md): Retrieves the day of the month from a given date or datetime
- [DAY\_OF\_WEEK](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/day_of_week.md): Determines the day of the week for a given date or datetime, where Monday is 1, Tuesday is 2, and so on
- [DAY\_OF\_YEAR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/day_of_year.md): Calculates the day of the year for a given date or datetime
- [DAYS\_IN\_MONTH](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/days_in_month.md): Calculates the number of days in the month for a given date or datetime
- [DAYS\_IN\_YEAR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/days_in_year.md): Calculates the number of days in a year for a given date or datetime, considering leap years
- [HOUR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/hour.md): Extracts the hour component from a given datetime
- [INTERVAL (Date)](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/interval-date.md): Adds a specified number of days, weeks, months, quarters, or years to a date
- [INTERVAL (DateTime)](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/interval-datetime.md): Adds a specified number of seconds, minutes, or hours to a datetime
- [MINUTE](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/minute.md): Extracts the minute component from a given datetime
- [MONTH](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/month.md): Retrieves the month component from a given date
- [NOW](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/now.md): Retrieves the current date and time
- [QUARTER](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/quarter.md): Retrieves the quarter of the year from a given date or datetime
- [SECOND](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/second.md): Extracts the second component from a given datetime
- [TIME\_PERIOD](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/time_period.md)
- [TIME\_PERIOD\_OFFSET](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/time_period_offset.md): Calculates the number of time periods between a given date and the current period
- [TODAY](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/today.md): Retrieves the current date
- [WEEK/WEEK\_OF\_YEAR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/week-week_of_year.md): Determines the week number of the year for a given date or datetime
- [YEAR](/savant-1/analyses/functions-and-expressions/functions-and-formulas/date-and-time/year.md): Retrieves the year component from a given date
