Click here to Skip to main content
15,441,434 members

Articles by g_p_l (Tip/Trick: 1)

Tip/Trick: 1

RSS Feed

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
3 Feb 2010   Updated: 3 Feb 2010   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 4,590     Bookmarked: 0   Downloaded: 0
Please Sign up or sign in to vote.
@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.
Web Developer
United Kingdom United Kingdom
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.