> -----Original Message----- > From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
> Csongor Fagyal wrote: > > > Oh and one more thing I am not really sure of: sometimes > defining the > > day as 3600*24 or the year as 3600*24*365 is not the best > idea... just > > think about leap years. How do you handle that? And there are some > > more "artifacts" in the Gregorian calendar, too... > > > But MySQL doesn't guarantee correctness in time values in the first > place. You can still insert "2002-02-31" as a date if you like: True. But the example of 3600*24*365 is obviously wrong. It should at a minimum be 3600*24*365.25, though that might cause some odd artifacts. The best idea would be to put logic in the code to implement the leap year rules. (Which are more complicated than you learned in elementary school! ;) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
