Articles by g_p_l (Tip/Trick: 1)

Tip/Trick: 1

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 0.00

Database Development

SQL Server

Get days of a month in SQL [Tip/Trick]

3 Feb 2010 Updated: 3 Feb 2010 Rating: 0.00/5 Votes: 0 Popularity: 0.00

Licence: CPOL Views: 4,900 Bookmarked: 0 Downloaded: 0

@dt is a datetime valuederive the first of this month, add a month to itthen subtract 1 day to get the last day of this monthselect days_of_month=day( dateadd(d,-1, dateadd(m,1, dateadd(d,1-day(@dt), @dt) ) ) )

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

g_p_l

Web Developer

United Kingdom

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.