Date anomaly

[ldoozer]

If i write the date to a date(type=date) field in the mysql database it stores the correct date.

However when returning the unix date using php code any date before the end of November 2010 outputs the day before the date that is in the database.

 

Is this something to do with clocks changing, or the servers time?

 

Any one else seen anything similar?

[jim_keller]

it's probably a timezone difference between where you are and where the server is. Try calling date_default_timezone_set( 'your timezone here' ) early in your code, but replace 'your timezone here' with a valid timezone from this list: http://us3.php.net/manual/en/timezones.php

[ldoozer]

I have checked the server time setting and shows the correct time, date and GMT +00 London zone.

 

Is this relevant to your last post?

[ldoozer]

Thanks jim_keller, your solution fixed the issue:

 

it's probably a timezone difference between where you are and where the server is. Try calling date_default_timezone_set( 'your timezone here' ) early in your code, but replace 'your timezone here' with a valid timezone from this list: http://us3.php.net/manual/en/timezones.php