Maximum day of the month

Hi,
Any funtion or method to find out the maximum day of the month?
i.e
if feb then 28
march then 31 and
april then 30
Please advise me,
rgds,
Soura
Hi
There are many previous posts that give you solutions see
http://tinyurl.com/r3ahf
John
"SouRa" wrote:

> Hi,
> Any funtion or method to find out the maximum day of the month?
> i.e
> if feb then 28
> march then 31 and
> april then 30
> Please advise me,
> rgds,
> Soura
|||Hi
declare @.d datetime
set @.d='20060210'
select datestring, case
when isdate(datestring/100*100+31) = 1 then 31
when isdate(datestring/100*100+30) = 1 then 30
when isdate(datestring/100*100+29) = 1 then 29
when isdate(datestring/100*100+28) = 1 then 28
end
from (
select convert(varchar,@.d,112) as datestring
) D
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:8288A2E2-17F0-409F-BE8A-F65DBB818376@.microsoft.com...
> Hi,
> Any funtion or method to find out the maximum day of the month?
> i.e
> if feb then 28
> march then 31 and
> april then 30
> Please advise me,
> rgds,
> Soura
|||Here is a sample script found on sqlservercentral.com written by AndrewP
which is very elegent:
DECLARE @.MonthINT
DECLARE @.YearINT
DECLARE @.DateSMALLDATETIME
SET@.Month = 2
SET@.Year = 2012
SETDATEFORMAT ymd
SET@.Date = CAST(@.Year AS CHAR(4)) + '/' + RTRIM(CAST((@.Month) AS CHAR(2)))
+ '/01'
SET@.Date = DATEADD(m, 1, @.Date)
SELECTDAY(DATEADD(d, -1, @.Date))
"Uri Dimant" wrote:

> Hi
> declare @.d datetime
> set @.d='20060210'
> select datestring, case
> when isdate(datestring/100*100+31) = 1 then 31
> when isdate(datestring/100*100+30) = 1 then 30
> when isdate(datestring/100*100+29) = 1 then 29
> when isdate(datestring/100*100+28) = 1 then 28
> end
> from (
> select convert(varchar,@.d,112) as datestring
> ) D
>
> "SouRa" <SouRa@.discussions.microsoft.com> wrote in message
> news:8288A2E2-17F0-409F-BE8A-F65DBB818376@.microsoft.com...
>
>