SET TIME ZONE
Use the SET TIME ZONE command to specify the time zone that should be used to interpret date and time values.
Syntax
SET TIME ZONE { time_zone | LOCAL | DEFAULT };
Parameters
| Parameter | Description |
|---|---|
| time_zone | Specifies the time zone using a valid time zone name, such as "America/New_York" or "Asia/Shanghai". You can find a list of all possible time_zone values here |
| LOCAL | Sets the time zone to the system's local time zone. |
| DEFAULT | Sets the time zone to the server's default time zone. |
Examples
SET TIME ZONE "America/New_York";
SET TIME ZONE LOCAL;
SET TIME ZONE DEFAULT;
