Timestamp Functions
Overview
Timestamp Functions
Overview
Timestamp functions return a date-time value based on a specified timestamp/interval. Oxla supports the following Timestamp functions:
| Functions | Description |
|---|---|
| CURRENT_TIMESTAMP() | Returns the current date and time as a timestamp data type. |
| FORMAT_TIMESTAMP() | Modifies the current timestamp into a different format. |
| UNIX_SECONDS() | Converts a given timestamp to a UNIX timestamp in seconds. |
| UNIX_MILLIS() | Converts a given timestamp to a UNIX timestamp in milliseconds. |
| UNIX_MICROS() | Converts a given timestamp to a UNIX timestamp in microseconds. |
| TIMESTAMP_SECONDS() | Converts a UNIX timestamp in seconds to a timestamp. |
| TIMESTAMP_MILLIS() | Converts a UNIX timestamp in milliseconds to a timestamp. |
| TIMESTAMP_MICROS() | Converts a UNIX timestamp in microseconds to a timestamp. |
| TIMESTAMP_TRUNC() | Truncates a given timestamp to the nearest time part. Supported time parts are YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND |
| EXTRACT() | Extracts some part of a specified timestamp or interval. |
| TO_TIMESTAMP() | Converts a string into a timestamp based on the provided format. |
| DATE_TRUNC() | Truncates intervals or timestamps/time zones to a specified field. |
| TO_CHAR() from Timestamp | Formats a timestamp into a string using a given format. |