SQL-Server-2005

SQL-Server

Get days of a month in SQL

rajivlipu

Rate me:

Please Sign up or sign in to vote.

2.00/5 (1 vote)

3 Feb 2010CPOL 8.3K   1   2

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

SQL

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)

Written By

rajivlipu

Software Developer (Junior) LUCID INFOTECH

 India

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

Comments and Discussions

First Prev Next

What is that? PeterMoon23-Jan-10 9:05 PeterMoon 23-Jan-10 9:05  Is this runnable at any Universe? What is the purpose of this? Elaborate? AspDotNetDev23-Jan-10 4:14 AspDotNetDev 23-Jan-10 4:14  Care to elaborate? [Forum Guidelines]

Last Visit: 31-Dec-99 18:00     Last Update: 19-Apr-24 10:29 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.