Change MySQL database timezone

1123980 pts.
Tags:
Database
MySQL
For a MySQL database, is there a way for me to change timezone? We need to change it from EST to GMT. Is there a certain code I can use for this? Thank you.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

No, it’s not possible to change the timezone for a single database within a MySQL instance. You can retrieve the server and client time_zone settings: SELECT @@global.time_zone, @@session.time_zone; You can also change the client timezone, or the timezone for the entire MySQL instance

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: