Not all Feb. has 28 days. It depends on whether it is a lunar year
or not. So Some Feb. will have 28 days and some have 29 days.
Pae
----- Original Message -----
From: "Andrew Braithwaite" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "'Roger Baklund'" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 7:52 AM
Subject: RE: mysql return days in month?
> Thanks for solving this all,
>
> I have do something ugly because I only have the yyyy-mm (3rd party DB)
> which ends up like this:
>
> Mysql> select dayofmonth((concat('2004-02','-01') + interval 1 month) -
> interval 1 day);
>
> Urrggg ;)
>
> Still, much more graceful (and more future proof) than what I just came up
> with:
>
> select case when (right('2002-04',2) = '02') then 28 when ('%09%04%06%11%'
> regexp right('2002-04',2)) then 30 else 31 end as daysinmonth;
>
> lol....
>
> Thanks
>
> Andrew
> Sql,query
>
> * Roger Baklund
> >You can start with the first day of the _next_ month, and go 1 day
back...:
> >
> >mysql> select dayofmonth('2002-11-01' - interval 1 day);
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
