convert mysql timezone

  1. K

    Ways to convert timezone in mysql

    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(...