On 3?22?, ??2?34?, "Rahul" <verma.car...@gmail.com> wrote:
> Hi,
>
> how we can find out no of days in a particular month.
> I am using sql server 2000
>
> Rahul
try this:)
declare @yearAndmonth varchar(10)
declare @suffix varchar(10)
select @suffix = '-01'
select @yearAndmonth = '2007-02'
--select dateadd(month,1,convert(datetime,@yearAndmonth+@suffix))
select datediff(
day
,convert(datetime,@yearAndmonth+@suffix)
,dateadd(month,1,convert(datetime,@yearAndmonth+@suffix))
)