Click here to Skip to main content
11,642,216 members (59,658 online)

Article Recommendation

Your Name:*
Your Email:*
Your friend's Email:*
The Message text:

Hi!,

This email was created by [your name] who thought you would be interested in the following Article:

"Get days of a month in SQL"
@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) ) ) )

CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!

Additional text:
 
Note: the details entered on this page will not be stored or used for any purpose other than for sending this email.

Advertise | Privacy | Mobile
Web02 | 2.8.150731.1 | Last Updated 18 Nov 2007
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid