how to set timezone in database

Published on Author bloggerfiveLeave a comment

 

In case our application would be spread world wide ,the  timezone variation issue is very common in database world.

The below example depicts how to set mysql database timezone to Asian time.

 

               SET GLOBAL time_zone = ‘+5:30’;
               SET GLOBAL time_zone = Asia/Calcutta;

 

 

Comments

comments

Leave a Reply

Your email address will not be published. Required fields are marked *