UNIX_TIMESTAMP()

[DeepBlerg]

Hi,

I have a timestamp field and the date & time appear fine in it through phpMyAdmin, however when I do a SELECT UNIX_TIMESTAMP(field), it returns a unix timestamp for me to use in PHP but it is in the future.

Any ideas why or how I can fix this?

 

[sleipnir214]

How far in the future?

A couple of minutes? Make sure that the clock on the MySQL server and the PHP server are synched.

Whole hour increments? Make sure the servers' clocks are set to the same time zone?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[DeepBlerg]

Hi sleipnir,

It is in the future by a considerable time - about 6 or 7 hours, also the timezones are different, I was not aware that MySQL had its own clock, I thought it just used system time. Do you know how to set the MySQL clock in Linux?

Thanks.

 

[sleipnir214]

Are MySQL and PHP running on the same machine?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[DeepBlerg]

Don't worry I fixed it, mysql server just needed a restart, after I had set the system timezone, mysql was still set on the previous time zone.