Page 1 of 1
mysql time problem
Posted: Tue Sep 09, 2008 5:24 am
by itsmani1
I am having time problem with mysql when i do:
2008-09-09 05:02:30
But server time is : 15:26:40 2008
why is this? any help?
thank you
Re: mysql time problem
Posted: Tue Sep 09, 2008 5:36 am
by onion2k
That's a bit weird. I could understand the number of hours being off because that could be due to the timezone setting, but for the minutes to be off as well... that's very odd. Is MySQL definitely on the same server as the webserver?
Re: mysql time problem
Posted: Tue Sep 09, 2008 5:49 am
by itsmani1
Sorry:
its like:
difference is only of hours.
I am having time problem with mysql when i do:
2008-09-09 05:26:40
But server time is : 15:26:40 2008
on mysql console when i tried :
Code: Select all
select @@global.time_zone, @@session.time_zone;
It says: system
why is this? any help?
thank you