> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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

```sql theme={null}
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](https://en.wikipedia.org/wiki/List%5Fof%5Ftz%5Fdatabase%5Ftime%5Fzones) |
| **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

```sql theme={null}
SET TIME ZONE "America/New_York";
```

```sql theme={null}
SET TIME ZONE LOCAL;
```

```sql theme={null}
SET TIME ZONE DEFAULT;
```
