Timestamp Functions
Timestamp functions return a date-time value based on a specified timestamp/interval. Oxla supports the following Timestamp functions:
Functions | Description |
Returns the current date and time as a timestamp data type. | |
Modifies the current timestamp into a different format. | |
Converts a given timestamp to a UNIX timestamp in seconds. | |
Converts a given timestamp to a UNIX timestamp in milliseconds. | |
Converts a given timestamp to a UNIX timestamp in microseconds. | |
Converts a UNIX timestamp in seconds to a timestamp. | |
Converts a UNIX timestamp in milliseconds to a timestamp. | |
Converts a UNIX timestamp in microseconds to a timestamp. | |
Truncates a given timestamp to the nearest time part. Supported time parts are YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND | |
Extracts some part of a specified timestamp or interval. |

