MySql time screw

Hello Just got new server like 2 weeks ago and after I have set everything and finally started coding i found out that mysql behaves strangly.

following query was returning screwed time.


select unix_timestamp(20030528022000);

1054106400

while it is suppose to be

1054102800

3540s difference

so I went and reinstalled mysql

but still that occurs but now it is only

60s

anyone knows how to fix this particular probelm thx.

 

 

 

 

Top