Change timezone in godaddy mysql server

[Prateek_2]

I need to change the timezone of mysql to 'Asia/Calcutta'. I am on shared goaddy hosting.
Please tell me how to do the same

[cereal]

Follow these instructions: http://dev.mysql.com/doc/refman/5.6/en/time-zone-support.html

But you should always save as UTC and then convert the datetime to the client local timezone.

[rch1231]

Hello,

below is a link to a page that shows you how to set the time zone in your PHP script so that php will display local time for each user.

http://www.sitepoint.com/synchronize-php-mysql-timezone-configuration/

[Prateek_2]

@rch1231 thanks :)