sql server programming: Hi,

how we can find out no of days in a particular month.
I am using sql server 2000

Rahul

On 3=D4=C222=C8=D5, =CF=C2=CE=E72=CA=B134=B7=D6, "Rahul" <verma.car...@gmai=
[quoted text, click to view]
try this:)
declare @yearAndmonth varchar(10)
declare @suffix varchar(10)
select @suffix =3D '-01'
select @yearAndmonth =3D '2007-02'

--select dateadd(month,1,convert(datetime,@yearAndmonth+@suffix))

select datediff(
day
,convert(datetime,@yearAndmonth+@suffix)
,dateadd(month,1,convert(datetime,@yearAndmonth+@suffix))
)