Re: MySQL 0 index date and time functions (mode or typo)?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dwight Altman wrote:
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?

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/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux