# Timestamps And Time Zones
__*time zone*__
+ Current session 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]