Home > Archive > PHP DB > May 2007 > Re: [PHP-DB] MySQL 0 index date and time functions (mode or typo)?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PHP-DB] MySQL 0 index date and time functions (mode or typo)?
|
|
|
| Dwight Altman wrote:
> In MySQL, regardless of the documentation version,
> http://dev.mysql.com/doc/refman/4.1...s.html#function
> _w 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?
Best to ask on the mysql list - http://lists.mysql.com/ - they will have
more experience with this sort of thing (and the mysql developers answer
questions there too so they might be able to give you more detail).
--
Postgresql & php tutorials
http://www.designmagick.com/
|
|
|
|
|