http://www.sqljunkies.com/HowTo/6676...C7FD826E5.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
"project" <bi********@rediffmail-dot-com.no-spam.invalid> wrote in message
news:40********@Usenet.com...
anybody can tell me how to find how many days in a month by using sql
quiery
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com