Days in Month

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

RE: Days in Month

' 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

Re: Days in Month

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

mysql return days in month?

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

Re: mysql return days in month?

: 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

Re: mysql return days in month?

* 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

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 more graceful (and more future proof) than what I just

Re: mysql return days in month?

, 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

RE: mysql return days in month?

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