| Function | Description |
| CURRENT_DATE() | Returns the current date in the local time zone set for 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 and returns the new datetime. |
| SESSIONTIMEZONE() | Returns the time zone for the database session. |
| TZ_OFFSET(time_zone) | Returns the offset for time_zone in hours and minutes. |
| 10.13.Timezone | ||||
| 10.13.1. | Understanding Time Zones | |||
| 10.13.2. | Time Zone-Related Functions | |||
| 10.13.3. | The Database Time Zone and Session Time Zone | |||
| 10.13.4. | Change timezone | |||