> For the complete documentation index, see [llms.txt](https://upsolver.gitbook.io/content/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://upsolver.gitbook.io/content/reference-1/functions-and-operators/functions/date-and-time.md). # Date & Time This section describes the following date and time functions:

Function	Description
ADD_TIME_ZONE_OFFSET	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	Casts string to date
DATE_ADD	Adds an interval value of type unit to timestamp. Subtraction can be performed by using a negative value
DATE_DIFF	Returns timestamp2 - timestamp1 expressed in terms of unit
DATE_TRUNC	Truncate a date to a given unit
DAY	Returns the day of the month from the timestamp
DAY_OF_WEEK	Returns the ISO day of the week from the timestamp. values range from 1 (Monday) to 7 (Sunday)
DAY_OF_YEAR	Returns the day of the year from timestamp. values range from 1 to 366
EXTRACT_TIMESTAMP	Convert a date or timestamp string to a date or timestamp, autodetecting the date format
FORMAT_DATETIME	Convert a datetime into a string
FROM_ISO8601_DATE	Parses the ISO 8601 formatted string into a date
FROM_UNIXTIME	Convert epoch seconds to a timestamp
HOUR	Returns the hour of the day from a timestamp. Values range from 0 to 23
MILLISECOND	Returns the millisecond of the second from the timestamp
MINUTE	Returns the minute of the hour from the timestamp
MONTH	Returns the month of the year from the timestamp
QUARTER	Returns the quarter of the year from the timestamp. Values range from 1 to 4
RUN_END_TIME	Returns the job execution end time
RUN_START_TIME	Returns the job execution start time
SECOND	Returns the second of the minute from the timestamp
SUBTRACT_TIME_ZONE_OFFSET	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	Convert a date to its Epoch (Unix) seconds representation, with fractional milliseconds
TO_UNIX_EPOCH_MILLIS	Convert a date to its Epoch (Unix) seconds representation
TO_UNIX_EPOCH_SECONDS	Convert a date to its Epoch (Unix) seconds representation
WEEK	Returns the ISO week of the year from the timestamp. Values range from 1 to 53
YEAR	Returns the year from the timestamp
YEAR_OF_WEEK	Returns the year of ISO week from the timestamp

--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://upsolver.gitbook.io/content/reference-1/functions-and-operators/functions/date-and-time.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.