Very Computer

Anybody know how to calc the number of days in a month, given a date ??

I can do it in Access/vb easily, but can't figure out how to do it in TSQL.
Forgive me if it's too easy - I'm new here...

Thanks
Darren

Darren
Look at this one
select day(dateadd(m,1,getdate())-day(dateadd(m,1,getdate())))

Quote:> Anybody know how to calc the number of days in a month, given a date ??

> I can do it in Access/vb easily, but can't figure out how to do it in
TSQL.
> Forgive me if it's too easy - I'm new here...

> Thanks
> Darren

Thanks Uri
It's just too easy when you know how...
Darren

I had to think about this one for a while.  In pseudo-English(? ;-)
instead of SQL you are saying

"What day of the month is (
The current date/time plus 1 month
minus
What day of the month is
The current date/time plus 1 month
)"

That is, today being 24/10/2002 in British, you are taking
24/11/2002 and then subtracting 24 to get the last date this
month, and then taking the day-of-month of that.  And it
doesn't matter that DATEADD(m,1,'2002-10-31') is '2002-11-30'
because in that case you get the same difference each time as
you subtract 30 from '2002-11-30'.  (Obviously it /would/
matter if DATEADD(m,1,'2002-10-31') were '2002-12-01',
but it isn't.)

Having said that, how do we feel about

SELECT CONVERT( int, DATEADD(m,1,GETDATE()) - GETDATE() ) ? ;-)

(Oh, and what if you start to execute either one at
'2002-10-31 23:59:59.99'... ;-)