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 back up MySQL databases using AutoMySQLBackup?

What is AutoMySQLBackup? AutoMySQLBackup is a script that allows you to schedule the automatic...

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 connect MySQL using Python?

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

How to take a Backup and Restore of MySQL Databases via Command Line?

mysqldump is an easy and quick tool to create a backup of MySQL databases. It creates a dump file...

How to change MySQL root password from WHM?

In this article, we will describe steps to change the root password of MySQL server from WHM....

  • 0 Users Found This Useful

Was this answer helpful?