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

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@multicam.com> wrote in message news:015501c797d4$7a5d6330$0e00a8c0@IT02... > 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