arijit_bons at yahoo dot co dot in (2013-01-30 07:21:29)

Timezone for India is now 'Asia/Kolkata'

Anonymous (2012-10-01 08:51:48)

MySQL supports whichever timezones you feed it!
https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html

YogeshGadiya at gmail dot com (2011-07-29 00:39:21)

You can have time zone set for India as 'Asia/Kolkata' this will add +5.30 to GMT time.
You will get proper time of your time zone.
Example:
<?php
$timezone = "Asia/Calcutta";
if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
echo date('d-m-Y H:i:s');
?>

You will get result as India time

khalidco at bigfoot dot com (2011-06-17 14:15:18)

Even though php supports 'Asia/Riyadh', MySQL doesn't!  I had to use '+3:00' instead, to over come that since it's pointless to set the time zone for the script and not the database activities.  To do it for both, do the following :

<?php
$timezone = "Asia/Riyadh";
if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);

mysql_query("SET SESSION time_zone = '+3:00'");
?>