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
'
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 PROTECTED]
Sent: Tuesday, April 04, 2006 2:48 PM
To: MySQL List
Subject: Days in Month
Hello
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
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
:
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
* 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