How to convert time zone in MySQL?

You can change the timezone in MySQL using php function CONVERT_TZ.

Following is the SQL command to change the timezone.

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

If your current time zone is MST and you want to change the time zone to USA new york, you can fire the below command.

SELECT CONVERT_TZ( NOW(),'US/MST','America/New_York' );

Related Articles

How to check active MS-SQL connections?

Following are the steps to check active database connection in the MS SQL server please follow...

How to Fix MySQL Error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed"?

Problem Statement MySQL service is stopped. Error Message 150206 4:42:12 [ERROR] Plugin...

How to rename MySQL Database table from phpMyAdmin?

It’s very easy to rename a table in phpMyAdmin. To do so, simply follow these steps: MySQL...

How to Fix Error Forcing close of thread 310 user: 'root' in MySQL?

Problem Statement MySQL server keeps on shutting down. Error Message C:\Program...

How to connect MySQL using Python?

There are several ways to use python to connect with the MySQL database. In this article, we will...

  • 0 Users Found This Useful

Was this answer helpful?