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;





Leave a Reply

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