I have an order management-based site where I query the time and convert it base on users Time Zone:
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
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
This topic is now closed. New replies are no longer allowed.