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

# Overview

Timestamp functions return a date-time value based on a specified timestamp/interval. Oxla supports the following Timestamp functions:

| **Functions**                                                                              | **Description**                                                                                                           |
| :----------------------------------------------------------------------------------------- | :------------------------------------------------------------------------------------------------------------------------ |
| [CURRENT\_TIMESTAMP()](/sql-reference/sql-functions/timestamp-functions/current-timestamp) | Returns the current date and time as a timestamp data type.                                                               |
| [FORMAT\_TIMESTAMP()](/sql-reference/sql-functions/timestamp-functions/format-timestamp)   | Modifies the current timestamp into a different format.                                                                   |
| [UNIX\_SECONDS()](/sql-reference/sql-functions/timestamp-functions/unix-seconds)           | Converts a given timestamp to a UNIX timestamp in seconds.                                                                |
| [UNIX\_MILLIS()](/sql-reference/sql-functions/timestamp-functions/unix-millis)             | Converts a given timestamp to a UNIX timestamp in milliseconds.                                                           |
| [UNIX\_MICROS()](/sql-reference/sql-functions/timestamp-functions/unix-macros)             | Converts a given timestamp to a UNIX timestamp in microseconds.                                                           |
| [TIMESTAMP\_SECONDS()](/sql-reference/sql-functions/timestamp-functions/timestamp-seconds) | Converts a UNIX timestamp in seconds to a timestamp.                                                                      |
| [TIMESTAMP\_MILLIS()](/sql-reference/sql-functions/timestamp-functions/timestamp-millis)   | Converts a UNIX timestamp in milliseconds to a timestamp.                                                                 |
| [TIMESTAMP\_MICROS()](/sql-reference/sql-functions/timestamp-functions/timestamp-micros)   | Converts a UNIX timestamp in microseconds to a timestamp.                                                                 |
| [TIMESTAMP\_TRUNC()](/sql-reference/sql-functions/timestamp-functions/timestamp-trunc)     | Truncates a given timestamp to the nearest time part. Supported time parts are YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND |
| [EXTRACT()](/sql-reference/sql-functions/timestamp-functions/extract)                      | Extracts some part of a specified timestamp or interval.                                                                  |
| [TO\_TIMESTAMP()](/sql-reference/sql-functions/timestamp-functions/to-timestamp)           | Converts a string into a timestamp based on the provided format.                                                          |
| [DATE\_TRUNC()](/sql-reference/sql-functions/timestamp-functions/date-trunc)               | Truncates intervals or timestamps/time zones to a specified field.                                                        |
| [TO\_CHAR() from Timestamp](/sql-reference/sql-functions/timestamp-functions/to-char)      | Formats a timestamp into a string using a given format.                                                                   |