Is there a function that I missed for calculating the number of days in a month?
No, but you can calculate it. One way: - Find the first of the month - Add a month - Subtract a day. That gives you the last day of the month. - Extract the day-of-the-month
Example:
SET @d = '2003-03-01';
SELECT @d,
DATE_SUB(
DATE_ADD(
DATE_SUB(@d,INTERVAL DAYOFMONTH(@d) - 1 DAY),
INTERVAL 1 MONTH),
INTERVAL 1 DAY)
AS 'last of month';
SELECT @d,
DAYOFMONTH(
DATE_SUB(
DATE_ADD(
DATE_SUB(@d,INTERVAL DAYOFMONTH(@d) - 1 DAY),
INTERVAL 1 MONTH),
INTERVAL 1 DAY)
)
AS 'days in month';Which produces this output:
+------------+---------------+ | @d | last of month | +------------+---------------+ | 2003-03-01 | 2003-03-31 | +------------+---------------+ +------------+---------------+ | @d | days in month | +------------+---------------+ | 2003-03-01 | 31 | +------------+---------------+
Easy! :-)
There are other solutions.
Steffan
MySQL --------------------------------------------------------------- T E L 6 0 2 . 5 7 9 . 4 2 3 0 | F A X 6 0 2 . 9 7 1 . 1 6 9 4 Steffan A. Cline [EMAIL PROTECTED] Phoenix, Az http://www.ExecuChoice.net USA AIM : SteffanC ICQ : 57234309 The Executive's Choice in Lasso driven Internet Applications ---------------------------------------------------------------
--------------------------------------------------------------------- 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
