It's not all that elegant, but how about this:
Mysql SELECT date_format(date_add('2002-10-01', interval -1 day), %d);
Basically, take the first day of the month, subtract one and figure out what
the day number is.
-- Jason
On 11/18/02 9:02 AM, Andrew Braithwaite [EMAIL PROTECTED] wrote:
* Andrew Braithwaite
Can anyone help? I want to know if there is an easy way to return the
number of days in a month from mysql.
Ideally there would be a function that did the following...
mysql SELECT DAYSINMONTH('2002-10');
+---+
| DAYINMONTH('2002-10') |
Thanks for solving this all,
I have do something ugly because I only have the -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
, 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 -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
PROTECTED]
Cc: 'Roger Baklund'
Subject: Re: mysql return days in month?
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