Time Zone Functions
| Function | Description |
|---|---|
| CURRENT_DATE | returns the current date in the local time zone in the database session |
| DBTIMEZONE | Returns the time zone for the database |
| NEW_TIME(x,time_zone1,time_zone2) | Converts x from time_zone1 to time_zone2 |
| SESSIONTIMEZONE | Returns the database session time zone |
| TZ_OFFSET(time_zone) | Returns the offset for time_zone in hours and minutes |
| SYS_EXTRACT_UTC | Extracts the UTC from a datetime value. |