We can change Mysql timezone by using CONVERT_TZ function.
You have to use below SQL command to change timezone
If you want to change your timezone to USA new York, you can run below command.
You have to use below SQL command to change timezone
Code:
SELECT CONVERT_TZ( NOW(),'current-time-zone','changed-time-zone' );
Code:
SELECT CONVERT_TZ( NOW(),'current-time-zone','changed-time-zone' );