Mysql CONVERT_TZ and Vise versa

Databases
1

Hello Forums,

I have an order management-based site where I query the time and convert it base on users Time Zone:

example:

SELECT CONVERT_TZ('table.date_col','+00:00',table.user_gmt) FROM table;

SELECT CONVERT_TZ(‘2004-01-01 12:00:00’,‘+00:00’,‘+10:00’) FROM table;
This will give me ‘2004-01-01 22:00:00’ w/c is accurate base on the the user’s timezone

Question:
When user Inputs 2004-01-01 22:00:00 I want to save it on the database as 2004-01-01 12:00:00 how can I reverse CONVERT_TZ

Thanks