At 12:15 PM 1/8/05, Tom Crimmins wrote:
[snip] datetime is "displayed" as YYYY-MM-DD HH:MM:SS - it is *not* stored that way. It is stored as a *nix timestamp - an integer number of seconds since 1970-01-01 00:00:00. [/snip]
Actually datetime is not stored as epoch time. It has a range from 1000-01-01 00:00:00 to 9999-12-31 23:59:59 because it is a combination of a date and a time field as Neculai wrote. You may be thinking of a timestamp, which is tored as a 4 byte int.
Thanks for correction. The lower limit on my 4.0.20 system appears to be 0001-01-01 00:00:00. Also, 4.0.20 appears to accept invalid dates, such as those with zero for year, month or day.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
