how to find how many days in a month by using sql quiery

[project]

anybody can tell me how to find how many days in a month by using sql
quiery

 

[One Handed Man \( OHM - Terry Burns \)]

Try This

select *, DaysInMonth([MyDate]) from MyTable;


--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

anybody can tell me how to find how many days in a month by using sql
quiery

 

[Greg Burns]

http://www.sqljunkies.com/HowTo/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

Create Function
udf_getNoOfDaysInMonth
(
@month int
,@year int
)
returns
int
as
begin
return datepart( dd,dateadd(dd,-1,(dateadd(mm,@month,dateadd(
yyyy,@year-1900,'19000101')))))
end

go

select dbo.udf_getNoOfDaysInMonth(2,2004)

go

anybody can tell me how to find how many days in a month by using sql
quiery