> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Date and time functions

> Build, convert, format, extract from and do arithmetic on dates, times and timestamps.

Build, convert, format, extract from and do arithmetic on dates, times and timestamps.

| Function | Type | What it does |
| - | - | - |
| [`add_months`](https://docs.e6data.com/query/sql/functions/date-time/add_months) | Scalar | Adds signed calendar months and clamps to month end. |
| [`convert_timezone`](https://docs.e6data.com/query/sql/functions/date-time/convert_timezone) | Scalar | Converts a timestamp to another time zone or converts a local time between time zones. |
| [`curdate`](https://docs.e6data.com/query/sql/functions/date-time/curdate) | Scalar | Returns the current date in the session timezone, falling back to UTC. |
| [`current_date`](https://docs.e6data.com/query/sql/functions/date-time/current_date) | Scalar | Returns the current date in the session timezone, falling back to UTC. |
| [`current_timestamp`](https://docs.e6data.com/query/sql/functions/date-time/current_timestamp) | Scalar | Returns the query-start timestamp with microsecond precision. |
| [`current_timezone`](https://docs.e6data.com/query/sql/functions/date-time/current_timezone) | Scalar | Returns the session timezone string, using UTC when unset. |
| [`date`](https://docs.e6data.com/query/sql/functions/date-time/date) | Scalar | Converts a value to DATE, with the same behavior as CAST(value AS DATE). |
| [`date_add`](https://docs.e6data.com/query/sql/functions/date-time/date_add) | Scalar | Adds calendar days or specified temporal units. |
| [`date_diff`](https://docs.e6data.com/query/sql/functions/date-time/date_diff) | Scalar | Returns local date boundaries with two arguments or complete elapsed units with three arguments. |
| [`date_format`](https://docs.e6data.com/query/sql/functions/date-time/date_format) | Scalar | Formats a date or timestamp as a string. |
| [`date_part`](https://docs.e6data.com/query/sql/functions/date-time/date_part) | Scalar | Extracts a requested temporal component. |
| [`date_sub`](https://docs.e6data.com/query/sql/functions/date-time/date_sub) | Scalar | Subtracts a signed number of days from a date. |
| [`date_trunc`](https://docs.e6data.com/query/sql/functions/date-time/date_trunc) | Scalar | Truncates a timestamp to a chosen granularity. |
| [`dateadd`](https://docs.e6data.com/query/sql/functions/date-time/dateadd) | Scalar | Adds a specified number of units to a date or timestamp. |
| [`datediff`](https://docs.e6data.com/query/sql/functions/date-time/datediff) | Scalar | Returns local date boundaries with two arguments or complete elapsed units with three arguments. |
| [`datepart`](https://docs.e6data.com/query/sql/functions/date-time/datepart) | Scalar | Extracts a requested temporal component. |
| [`datetime`](https://docs.e6data.com/query/sql/functions/date-time/datetime) | Scalar | Sets a timestamp’s time zone without changing the instant it represents. |
| [`day`](https://docs.e6data.com/query/sql/functions/date-time/day) | Scalar | Extracts the day-of-month component. |
| [`dayname`](https://docs.e6data.com/query/sql/functions/date-time/dayname) | Scalar | Returns the three-letter English weekday name. |
| [`dayofweek`](https://docs.e6data.com/query/sql/functions/date-time/dayofweek) | Scalar | Extracts the Sunday-based weekday number from a date or timestamp. |
| [`dayofweekiso`](https://docs.e6data.com/query/sql/functions/date-time/dayofweekiso) | Being confirmed | Previous docs; being confirmed. |
| [`days`](https://docs.e6data.com/query/sql/functions/date-time/days) | Scalar | Extracts the day-of-month component. |
| [`extract`](https://docs.e6data.com/query/sql/functions/date-time/extract) | Scalar | Extracts an applicable calendar or clock component from a temporal value. |
| [`format_date`](https://docs.e6data.com/query/sql/functions/date-time/format_date) | Scalar | Formats a date as a string. |
| [`format_timestamp`](https://docs.e6data.com/query/sql/functions/date-time/format_timestamp) | Scalar | Formats a timestamp as a string. |
| [`from_unixtime`](https://docs.e6data.com/query/sql/functions/date-time/from_unixtime) | Scalar | Converts epoch seconds to a UTC timestamp or formatted string. |
| [`from_unixtime_withunit`](https://docs.e6data.com/query/sql/functions/date-time/from_unixtime_withunit) | Scalar | Converts an epoch value in seconds or milliseconds to a UTC timestamp. |
| [`from_utc_timestamp`](https://docs.e6data.com/query/sql/functions/date-time/from_utc_timestamp) | Scalar | Converts UTC wall time to the requested local wall time. |
| [`generate_date_array`](https://docs.e6data.com/query/sql/functions/date-time/generate_date_array) | Scalar | Generates an inclusive stepped array of dates. |
| [`generate_timestamp_array`](https://docs.e6data.com/query/sql/functions/date-time/generate_timestamp_array) | Scalar | Generates an inclusive stepped array of timestamps. |
| [`getdate`](https://docs.e6data.com/query/sql/functions/date-time/getdate) | Scalar | Returns the query-start timestamp with microsecond precision. |
| [`getutcdate`](https://docs.e6data.com/query/sql/functions/date-time/getutcdate) | Scalar | Returns the current UTC date. |
| [`hour`](https://docs.e6data.com/query/sql/functions/date-time/hour) | Scalar | Extracts the hour component. |
| [`last_day`](https://docs.e6data.com/query/sql/functions/date-time/last_day) | Scalar | Returns the last calendar date of the input month. |
| [`last_day_of_month`](https://docs.e6data.com/query/sql/functions/date-time/last_day_of_month) | Scalar | Returns the last calendar date of the input month. |
| [`make_date`](https://docs.e6data.com/query/sql/functions/date-time/make_date) | Scalar | Constructs a date from year, month and day. |
| [`make_time`](https://docs.e6data.com/query/sql/functions/date-time/make_time) | Scalar | Constructs a time with fractional-second precision. |
| [`make_timestamp`](https://docs.e6data.com/query/sql/functions/date-time/make_timestamp) | Scalar | Constructs a UTC timestamp from calendar and time components. |
| [`minute`](https://docs.e6data.com/query/sql/functions/date-time/minute) | Scalar | Extracts the minute component. |
| [`month`](https://docs.e6data.com/query/sql/functions/date-time/month) | Scalar | Extracts the month component. |
| [`monthname`](https://docs.e6data.com/query/sql/functions/date-time/monthname) | Scalar | Returns the three-letter English month name. |
| [`months_between`](https://docs.e6data.com/query/sql/functions/date-time/months_between) | Scalar | Returns a signed fractional month difference, first minus second. |
| [`next_day`](https://docs.e6data.com/query/sql/functions/date-time/next_day) | Scalar | Returns the next matching weekday strictly after the input date. |
| [`now`](https://docs.e6data.com/query/sql/functions/date-time/now) | Scalar | Returns the query-start timestamp with microsecond precision. |
| [`parse`](https://docs.e6data.com/query/sql/functions/date-time/parse) | Being confirmed | Previous docs; being confirmed. |
| [`parse_date`](https://docs.e6data.com/query/sql/functions/date-time/parse_date) | Being confirmed | Previous docs; being confirmed. |
| [`parse_datetime`](https://docs.e6data.com/query/sql/functions/date-time/parse_datetime) | Being confirmed | Previous docs; being confirmed. |
| [`parse_timestamp`](https://docs.e6data.com/query/sql/functions/date-time/parse_timestamp) | Scalar | Parses a formatted timestamp string and returns a UTC timestamp. |
| [`quarter`](https://docs.e6data.com/query/sql/functions/date-time/quarter) | Scalar | Extracts the calendar quarter from a date or timestamp. |
| [`second`](https://docs.e6data.com/query/sql/functions/date-time/second) | Scalar | Extracts the second component. |
| [`timestamp`](https://docs.e6data.com/query/sql/functions/date-time/timestamp) | Scalar | Constructs a UTC timestamp from string, date or timestamp input. |
| [`timestamp_add`](https://docs.e6data.com/query/sql/functions/date-time/timestamp_add) | Scalar | Adds a signed duration or calendar interval to a timestamp. |
| [`timestamp_diff`](https://docs.e6data.com/query/sql/functions/date-time/timestamp_diff) | Scalar | Returns complete elapsed units from start to end. |
| [`timestamp_micros`](https://docs.e6data.com/query/sql/functions/date-time/timestamp_micros) | Scalar | Converts Unix epoch microseconds to a UTC timestamp. |
| [`timestamp_millis`](https://docs.e6data.com/query/sql/functions/date-time/timestamp_millis) | Scalar | Converts Unix epoch milliseconds to a UTC timestamp. |
| [`timestamp_seconds`](https://docs.e6data.com/query/sql/functions/date-time/timestamp_seconds) | Scalar | Converts Unix epoch seconds to a UTC timestamp. |
| [`timestampadd`](https://docs.e6data.com/query/sql/functions/date-time/timestampadd) | Scalar | Adds a signed duration or calendar interval to a timestamp. |
| [`timestampdiff`](https://docs.e6data.com/query/sql/functions/date-time/timestampdiff) | Scalar | Returns complete elapsed units from start to end. |
| [`to_char`](https://docs.e6data.com/query/sql/functions/date-time/to_char) | Scalar | Formats a temporal, numeric, binary or string value as text. |
| [`to_date`](https://docs.e6data.com/query/sql/functions/date-time/to_date) | Scalar | Converts a value to a date. |
| [`to_time`](https://docs.e6data.com/query/sql/functions/date-time/to_time) | Scalar | Converts time text to a TIME value using a Spark-style format supplied for each row. |
| [`to_timestamp`](https://docs.e6data.com/query/sql/functions/date-time/to_timestamp) | Scalar | Converts a value to a timezone-bearing timestamp. |
| [`to_timestamp_ntz`](https://docs.e6data.com/query/sql/functions/date-time/to_timestamp_ntz) | Scalar | Converts a value to a timezone-free timestamp. |
| [`to_timestamp_tz`](https://docs.e6data.com/query/sql/functions/date-time/to_timestamp_tz) | Scalar | Converts a value to a timezone-bearing timestamp. |
| [`to_unix_timestamp`](https://docs.e6data.com/query/sql/functions/date-time/to_unix_timestamp) | Scalar | Returns epoch seconds from a timestamp or explicitly formatted string. |
| [`to_unixtime`](https://docs.e6data.com/query/sql/functions/date-time/to_unixtime) | Scalar | Returns the number of seconds since the Unix epoch for a timestamp. |
| [`to_utc_timestamp`](https://docs.e6data.com/query/sql/functions/date-time/to_utc_timestamp) | Scalar | Converts local wall time in a timezone to UTC wall time. |
| [`to_varchar`](https://docs.e6data.com/query/sql/functions/date-time/to_varchar) | Scalar | Formats a temporal, numeric, binary or string value as text. |
| [`trunc`](https://docs.e6data.com/query/sql/functions/date-time/trunc) | Scalar | Truncates a date or timestamp to the specified unit and returns a DATE. |
| [`try_to_date`](https://docs.e6data.com/query/sql/functions/date-time/try_to_date) | Scalar | Converts a date representation, returning NULL on parse failure. |
| [`try_to_timestamp`](https://docs.e6data.com/query/sql/functions/date-time/try_to_timestamp) | Scalar | Parses a value as a timestamp without a timezone, returning NULL on a failed supported conversion. |
| [`try_to_timestamp_ntz`](https://docs.e6data.com/query/sql/functions/date-time/try_to_timestamp_ntz) | Scalar | Parses a value as a timestamp without a timezone, returning NULL on a failed supported conversion. |
| [`unix_timestamp`](https://docs.e6data.com/query/sql/functions/date-time/unix_timestamp) | Scalar | Returns epoch seconds from a timestamp or explicitly formatted string. |
| [`week`](https://docs.e6data.com/query/sql/functions/date-time/week) | Being confirmed | Previous docs; being confirmed. |
| [`weekday`](https://docs.e6data.com/query/sql/functions/date-time/weekday) | Scalar | Returns the weekday number with Monday numbered zero. |
| [`weekiso`](https://docs.e6data.com/query/sql/functions/date-time/weekiso) | Being confirmed | Previous docs; being confirmed. |
| [`weekofyear`](https://docs.e6data.com/query/sql/functions/date-time/weekofyear) | Scalar | Extracts the ISO 8601 week number component. |
| [`year`](https://docs.e6data.com/query/sql/functions/date-time/year) | Scalar | Extracts the year component. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.