MySQL 0 index date and time functions (mode or typo)?
| From: | Dwight Altman | Date: | Wed, 16 May 2007 16:08:39 +0000 |
| Subject: | MySQL 0 index date and time functions (mode or typo)? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-43608@lists.php.net to get a copy of this message | ||
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