# Converting Timezones
__*CONVERT_TZ function*__
+ **`CONVERT_TZ(dt,from_tz,to_tz)`**:
```
tidb> SELECT CONVERT_TZ("2022-01-01 10:00:00", "Europe/Amsterdam", "Asia/Singapore");
+-------------------------------------------------------------------------+
| CONVERT_TZ("2022-01-01 10:00:00", "Europe/Amsterdam", "Asia/Singapore") |
+-------------------------------------------------------------------------+
| 2022-01-01 17:00:00                                                     |
+-------------------------------------------------------------------------+
1 row in set (0.01 sec)
```

------------------------------------------------------------
- DATEDIFF () return the number of days between two days