TSQL Function

v1c · Post by **v1c** » 06 Dec 2006, 14:24

Hi Guys

Anyone know of a TSQL function to grab the number of days in a month, or will I have to calculate it myself?

Thanks

viceroy · Post by **viceroy** » 06 Dec 2006, 14:29

will you just be inputing a month name, or number or can you input a date and need the max days for the month?

v1c · Post by **v1c** » 07 Dec 2006, 06:56

I've got the following...

SELECT DAY(DATEADD (m, 1, DATEADD (d, 1 - DAY(GETDATE()), GETDATE())) - 1) as NumDays

Lets hope it works.

viceroy · Post by **viceroy** » 07 Dec 2006, 09:59

Yeah, thats about the simplest way of getting it