[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