# Date and time functions

Date and time functions perform operations on date and time values to calculate, extract, or format temporal information and return a result.

The following functions are available in Qlik Open Lakehouse:

| Function | Description |
| --- | --- |
| [ADD_TIME_ZONE_OFFSET](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/add_time_zone_offset.htm) | Add a timezone offset to a date. The timezone offset can be in any of the standard formats accepted by Java's ZoneId.of method (America/New\_York, +0200, etc.) |
| [DATE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/date.htm) | Casts string to date |
| [DATE_ADD](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/date_add.htm) | Adds an interval value of type unit to timestamp. Subtraction can be performed by using a negative value |
| [DATE_DIFF](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/date_diff.htm) | Returns timestamp2 - timestamp1 expressed in terms of unit |
| [DATE_TRUNC](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/date_trunc.htm) | Truncate a date to a given unit |
| [DAY](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/day.htm) | Returns the day of the month from the timestamp |
| [DAY_OF_WEEK](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/day_of_week.htm) | Returns the ISO day of the week from the timestamp. values range from 1 (Monday) to 7 (Sunday) |
| [DAY_OF_YEAR](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/day_of_year.htm) | Returns the day of the year from timestamp. values range from 1 to 366 |
| [EXTRACT_TIMESTAMP](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/extract_timestamp.htm) | Convert a date or timestamp string to a date or timestamp, autodetecting the date format |
| [FORMAT_DATETIME](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/format_datetime.htm) | Convert a datetime into a string |
| [FROM_ISO8601_DATE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/from_iso8601_date.htm) | Parses the ISO 8601 formatted string into a date |
| [FROM_UNIXTIME](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/from_unixtime.htm) | Convert epoch seconds to a timestamp |
| [HOUR](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/hour.htm) | Returns the hour of the day from a timestamp. Values range from 0 to 23 |
| [MILLISECOND](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/millisecond.htm) | Returns the millisecond of the second from the timestamp |
| [MINUTE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/minute.htm) | Returns the minute of the hour from the timestamp |
| [MONTH](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/month.htm) | Returns the month of the year from the timestamp |
| [QUARTER](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/quarter.htm) | Returns the quarter of the year from the timestamp. Values range from 1 to 4 |
| [RUN_END_TIME](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/run_end_time.htm) | Returns the job execution end time |
| [RUN_START_TIME](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/run_start_time.htm) | Returns the job execution start time |
| [SECOND](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/second.htm) | Returns the second of the minute from the timestamp |
| [SUBTRACT_TIME_ZONE_OFFSET](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/subtract_time_zone_offset.htm) | Subtract a timezone offset from a date. The timezone offset can be in any of the standard formats accepted by Java's `ZoneId.of` method (America/New\_York, +0200, etc) |
| [TO_UNIXTIME](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/to_unixtime.htm) | Convert a date to its Epoch (Unix) seconds representation, with fractional milliseconds |
| [TO_UNIX_EPOCH_MILLIS](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/to_unix_epoch_millis.htm) | Convert a date to its Epoch (Unix) seconds representation |
| [TO_UNIX_EPOCH_SECONDS](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/to_unix_epoch_seconds.htm) | Convert a date to its Epoch (Unix) seconds representation |
| [WEEK](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/week.htm) | Returns the ISO week of the year from the timestamp. Values range from 1 to 53 |
| [YEAR](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/year.htm) | Returns the year from the timestamp |
| [YEAR_OF_WEEK](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/date-and-time/year_of_week.htm) | Returns the year of ISO week from the timestamp |