[wp-hackers] Internal representation of time

Alex Günsche ag.ml2008 at zirona.com
Fri Mar 14 14:30:55 GMT 2008


On Fri, 2008-03-14 at 14:19 +0000, James Davis wrote:
> The range of dates which can be represented by Unix timestamps 
> (1901-12-13 to 2038-01-18) is a small subset of the range of dates which 
> can be represented by MySQL DATETIME (1000-01-01 to 9999-12-31).
> 
> At the moment entering a date outside of Unix timestamp range results in 
> the correct date being stored (sometimes!) in the database but presented 
> as 1970-01-01 to the user.

Little correction: Unix timestamps are always defined as the seconds
elapsed since 1970-01-01.

Alex

-- 
Alex Günsche, Zirona OpenSource-Consulting
Blogs: http://www.zirona.com/ | http://www.regularimpressions.net
*** Want to test the shiny new release of InstantUpgrade? ***
http://www.zirona.com/blog/software/instantupgrade-10-beta/



More information about the wp-hackers mailing list