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:

Code: Select all

SELECT now() as now;
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:

Code: Select all

SELECT now() as now;
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