"Mike Blezien" <[EMAIL PROTECTED]> wrote on 04/04/2006 02:47:50 PM:
> Hello,
>
> is there a MySQL function to determine the total days of any given
> month, IE if
> current month is April, is there a function or query to find the
> total days of
> the month?
>
> TIA,
> Mike(mickalo)Blezien
>
04-02-05');
-> '2004-02-29'
mysql> SELECT LAST_DAY('2004-01-01 01:01:01');
-> '2004-01-31'
mysql> SELECT LAST_DAY('2003-03-32');
-> NULL
> -Original Message-
> From: Mike Blezien [mailto:[EMAIL PRO
Hello,
is there a MySQL function to determine the total days of any given month, IE if
current month is April, is there a function or query to find the total days of
the month?
TIA,
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Soluti
EMAIL 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" <[E
27;" <[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 -mm (3rd party DB)
> which ends up like this:
>
> Mysql> select dayof
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 cam
* 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') |
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]> wro
Hi all,
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') |
+---+
|
