Timestamp Functions
| Function | Description |
|---|---|
| CURRENT_TIMESTAMP | Returns a TIMESTAMP WITH TIME ZONE for the session |
| EXTRACT | Extracts and returns the year, month, day, hour, minute, second, or time zone from x. |
| FROM_TZ(x, time_zone) | Merges xand time_zone into one value. |
| LOCALTIMESTAMP | Returns a TIMESTAMP for the session. |
| SYSTIMESTAMP | Returns a TIMESTAMP WITH TIME ZONE for the database. |
| SYS_EXTRACT_UTC(x) | Converts the TIMESTAMP WITH TIMEZONE x to a TIMESTAMP in UTC. |
| TO_TIMESTAMP(x, [format]) | Converts the string x to a TIMESTAMP. |
| TO_TIMESTAMP_TZ(x, [format]) | Converts the string x to a TIMESTAMP WITH TIMEZONE. |