Click here to Skip to main content
12,395,871 members (62,595 online)
Click here to Skip to main content
Add your own
alternative version

Stats

1.9K views
Posted

Get days of a month in SQL

, 3 Feb 2010 CPOL
@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) ) ) )

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

3 Feb 2010
rajivlipu
1 alternative  
select days_of_month=day(dateadd(mm,-1,'12-feb-2010'),-1) :laugh:

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

| | Privacy | Terms of Use | Mobile
Web02 | 2.8.160721.1 | Last Updated 4 Feb 2010
Article Copyright 2010 by g_p_l
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid