how to set timezone in database
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;