Click here to Skip to main content
13,194,231 members (49,088 online)
Click here to Skip to main content
Add your own
alternative version

Stats

2.7K views
Posted 3 Feb 2010

Get days of a month in SQL

, 3 Feb 2010
Rate this:
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) ) ) )
@dt is a datetime value

derive the first of this month, add a month to it
then subtract 1 day to get the last day of this month

<pre>select days_of_month=day(<br />
        dateadd(d,-1,<br />
            dateadd(m,1,<br />
                dateadd(d,1-day(@dt), @dt)<br />
                )<br />
            )<br />
        )</pre><br />

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

g_p_l
Web Developer
United Kingdom United Kingdom
No Biography provided

You may also be interested in...

Comments and Discussions

 
-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.171018.2 | Last Updated 4 Feb 2010
Article Copyright 2010 by g_p_l
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid