In MySQL, regardless of the documentation version, http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html#function _week I've seen the explanation for receiving a 0 from the WEEK function depending on the mode setting which causes a range between 0-53. But what about: DAYOFMONTH 0 to 31 MONTH 0 to 12 I was wondering if 0 may be for invalid dates, but I get NULL for the following invalid date: SELECT MONTH( '1998-14-03' ), DAYOFMONTH( '1998-14-03' ) When might I receive a 0 for these two functions? Regards, Dwight -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
