# Date/Time Functions and Operators **Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API Functions and operators for working with dates, times, timestamps, and intervals. Use date/time functions to: - **Perform date arithmetic** with operators for addition, subtraction, and scaling, and convert between time zones. - **Extract and truncate** subfields such as the year, month, or hour from a value. - **Construct and convert** dates, times, and timestamps from component fields or Unix epoch values. - **Normalize intervals** into larger units. - **Get the current date and time**. - **Apply fiscal and localized calendars** to align results with your business calendar. ## Considerations - Most functions and operators accept `time`, `timestamp`, and `timestamptz` values. - Data 360 SQL outputs interval data in the [ISO 8601 style](https://en.wikipedia.org/wiki/ISO\_8601#Time_intervals). For example, `P1DT2H3M4S` corresponds to 1 day, 2 hours, 3 minutes, and 4 seconds. For more information about supported types, see [Date/Time Types](/docs/data/data-cloud-query-guide/references/dc-sql-reference/datetime.md). ## Operators Perform date arithmetic and time-zone conversion: - [Date/Time Operators](/docs/data/data-cloud-query-guide/references/dc-sql-reference/datetime-operators.md) — Arithmetic operators for dates, times, and intervals, and the `at time zone` conversion operator. ## Extraction and Truncation Retrieve or truncate subfields of a value: - [DATE_TRUNC](/docs/data/data-cloud-query-guide/references/dc-sql-reference/date-trunc.md) — Truncate a value to a specified precision. - [EXTRACT and date_part](/docs/data/data-cloud-query-guide/references/dc-sql-reference/extract.md) — Retrieve a subfield, such as the year or hour, from a value. - [SECOND](/docs/data/data-cloud-query-guide/references/dc-sql-reference/second.md) — Get the second from a timestamp or interval. - [MINUTE](/docs/data/data-cloud-query-guide/references/dc-sql-reference/minute.md) — Get the minute from a timestamp or interval. - [HOUR](/docs/data/data-cloud-query-guide/references/dc-sql-reference/hour.md) — Get the hour from a timestamp or interval. - [DAY](/docs/data/data-cloud-query-guide/references/dc-sql-reference/day.md) — Get the day from a timestamp or interval. - [WEEK](/docs/data/data-cloud-query-guide/references/dc-sql-reference/week.md) — Get the ISO 8601 week number from a timestamp. - [MONTH](/docs/data/data-cloud-query-guide/references/dc-sql-reference/month.md) — Get the month from a timestamp or interval. - [QUARTER](/docs/data/data-cloud-query-guide/references/dc-sql-reference/quarter.md) — Get the quarter from a timestamp. - [YEAR](/docs/data/data-cloud-query-guide/references/dc-sql-reference/year.md) — Get the year from a timestamp or interval. - [DAYNAME](/docs/data/data-cloud-query-guide/references/dc-sql-reference/dayname.md) — Return an abbreviated day name. - [MONTHNAME](/docs/data/data-cloud-query-guide/references/dc-sql-reference/monthname.md) — Return an abbreviated month name. - [DAYOFWEEK](/docs/data/data-cloud-query-guide/references/dc-sql-reference/dayofweek.md) — Return a day number from Sunday (`0`) through Saturday (`6`). ## Date Arithmetic Add to and measure the difference between dates: - [DATE_ADD](/docs/data/data-cloud-query-guide/references/dc-sql-reference/date-add.md) — Add a multiple of a date unit to a date or timestamp. - [DATEDIFF](/docs/data/data-cloud-query-guide/references/dc-sql-reference/datediff.md) — Measure the difference between two timestamps in a specified unit. ## Construction and Conversion Build values from parts or convert from Unix epoch: - [MAKE_DATE](/docs/data/data-cloud-query-guide/references/dc-sql-reference/make-date.md) — Create a date from year, month, and day fields. - [MAKE_TIME](/docs/data/data-cloud-query-guide/references/dc-sql-reference/make-time.md) — Create a time from hour, minute, and seconds fields. - [MAKE_TIMESTAMP](/docs/data/data-cloud-query-guide/references/dc-sql-reference/make-timestamp.md) — Create a timestamp from component fields. - [TO_TIMESTAMP](/docs/data/data-cloud-query-guide/references/dc-sql-reference/to-timestamp.md) — Convert Unix epoch seconds to a timestamp. ## Interval Adjustment Normalize intervals into larger units: - [JUSTIFY_DAYS](/docs/data/data-cloud-query-guide/references/dc-sql-reference/justify-days.md) — Represent 30-day periods as months. - [JUSTIFY_HOURS](/docs/data/data-cloud-query-guide/references/dc-sql-reference/justify-hours.md) — Represent 24-hour periods as days. - [JUSTIFY_INTERVAL](/docs/data/data-cloud-query-guide/references/dc-sql-reference/justify-interval.md) — Apply both adjustments with sign corrections. ## Current Date and Time Return current date and time values: - [CURRENT_DATE](/docs/data/data-cloud-query-guide/references/dc-sql-reference/current-date.md) — The current date. - [CURRENT_TIME](/docs/data/data-cloud-query-guide/references/dc-sql-reference/current-time.md) — The current time of day. - [CURRENT_TIMESTAMP](/docs/data/data-cloud-query-guide/references/dc-sql-reference/current-timestamp.md) — The current date and time. - [NOW](/docs/data/data-cloud-query-guide/references/dc-sql-reference/now.md) — The current date and time. - [GETDATE](/docs/data/data-cloud-query-guide/references/dc-sql-reference/getdate.md) — Return the current timestamp with time zone. - [SYSDATE](/docs/data/data-cloud-query-guide/references/dc-sql-reference/sysdate.md) — Return the current timestamp without time zone. ## Calendar Options Align results with a fiscal or localized calendar: - [Fiscal Calendar Options](/docs/data/data-cloud-query-guide/references/dc-sql-reference/fiscal-calendar-options.md) — Configure standard or custom fiscal years. - [Localized Week Options](/docs/data/data-cloud-query-guide/references/dc-sql-reference/localized-week-options.md) — Define the start of a week and a year. ## Related Documentation - [Date/Time Types](/docs/data/data-cloud-query-guide/references/dc-sql-reference/datetime.md) - [Scalar Functions](/docs/data/data-cloud-query-guide/references/dc-sql-reference/scalar-functions.md)