TrinityTuts Tips

Convert timestamp to local time MYSQL

You can convert saved MySql timestamp according to your local timestamp in MySql please check below code snippet in which I convert UTC to India time zone.

SELECT id, convert_tz(`updated_time`, '-00:00','+05:30') FROM `nmrl_orders` WHERE 1

Thanks