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:
mysql> create table temp (date datetime); Query OK, 0 rows affected
mysql> insert into temp(date) values ("2002-02-31");
Query OK, 1 row affected
mysql> select * from temp;
+---------------------+
| date |
+---------------------+
| 2002-02-31 00:00:00 |
+---------------------+
1 row in set
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
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
