Time zone issue. urgent!

Hai folks,

i am running wamp server on a windows7 laptop.

<?php 
$timezone = "Asia/Riyadh"; 
if(function_exists('date_default_timezone_set')){
  date_default_timezone_set($timezone); 
}else{
  echo '********* ZONE NOT SET **********';
}

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

Code (markup):

echo date('Y-m-d H:i:s');

Code (markup):

result : 2012-05-05 18:19:26
actual time now here : Saturday, 5 May 2012, 08:26:47 AST
current laptop system tray clock shows : Saturday, 5 May 2012, 08:26 AM

So the result timing is wrong. what could be the problem?

 

Maybe the MySQL database is using a different time setting and not system time?

 

Hai dennis,
actually echo date('Y-m-d H:i:s'); have nothing to do with mysql as its a php command. so i think here mysql is not a concern.