Ways to convert timezone in mysql

[kumkumsharma]

We can change Mysql timezone by using CONVERT_TZ function.

You have to use below SQL command to change timezone

SELECT CONVERT_TZ( NOW(),'current-time-zone','changed-time-zone' );

If you want to change your timezone to USA new York, you can run below command.

SELECT CONVERT_TZ( NOW(),'current-time-zone','changed-time-zone' );