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
