Re: days in a month

[Paul Svirin]

Hey, here comes your script:

SELECT CONCAT(dt.d, '-', days.d) as dates FROM (SELECT CONCAT(a1,b1) as d FROM (SELECT '0' as a1 UNION ALL SELECT '1' UNION ALL SELECT '2' UNION ALL SELECT '3') a JOIN (SELECT '0' as b1 UNION ALL SELECT '1' UNION ALL SELECT '2' UNION ALL SELECT '3' UNION ALL SELECT '4' UNION ALL SELECT '5' UNION ALL SELECT '6' UNION ALL SELECT '7' UNION ALL SELECT '8' UNION ALL SELECT '9') b WHERE CONVERT(CONCAT(a1, b1), UNSIGNED ) <= ( select DAY(CONCAT('2008-02','-01') + INTERVAL 1 MONTH - INTERVAL 1 DAY) ) AND CONCAT(a1,b1)<>'00') days JOIN (SELECT '2008-02' as d) dt ORDER BY dates;

The argument comes in format 'YYYY-MM' (here in this example there are two occurances, look for them).

hope that helps.

-----------------------
StarWind Software developer (http://www.starwindsoftware.com)