# Timestamps And Time Zones
__*time zone*__
+ Current time zone: `SELECT @@time_zone;` 
+ When stored, the**TIMESTAMP** value is converted from the current time zone to UTC
+ When queried, the data is converted from UTC to the current time zone
```
tidb> set time_zone='~!@+09:00@!~';
tidb> create table test.dropme (~!@d1 timestamp, d2 datetime@!~);
tidb> insert into test.dropme values (now(), now());
tidb> select * from test.dropme;
+---------------------+---------------------+
| d1                  | d2                  |
+---------------------+---------------------+
| 2022-02-06 01:12:23 | 2022-02-06 01:12:23 |
+---------------------+---------------------+
tidb> set time_zone='~!@+08:00@!~';
tidb> select * from test.dropme;
+---------------------+---------------------+
| d1                  | d2                  |
+---------------------+---------------------+
| 2022-02-06 ~!@00:12:23@!~ | 2022-02-06 01:12:23 |
+---------------------+---------------------+
```

------------------------------------------------------------
[no notes]