Hey,
I think this table is self-explanatory:
First day
Mode of week Range Week 1 is the first week .
0 Sunday 0-53 with a Sunday in this year
1 Monday 0-53 with more than 3 days this year
2 Sunday 1-53 with a Sunday in this year
3 Monday 1-53 with more than 3 days this year
4 Sunday 0-53 with more than 3 days this year
5 Monday 0-53 with a Monday in this year
6 Sunday 1-53 with more than 3 days this year
7 Monday 1-53 with a Monday in this year
--
itoctopus - http://www.itoctopus.com
""Dwight Altman"" <dwight@xxxxxxxxxxxx> wrote in message
news:015501c797d4$7a5d6330$0e00a8c0@xxxxxxx
> 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
