skip to main | skip to sidebar

C#, ASP.Net, Ajax, Javascript, SQL Help

29 September 2008

To Find No Of Days in a month -SQL

DECLARE @date datetime
set @date='1/1/2008'
DECLARE @dayCount int
--To Find No Of Days in a month
SET @dayCount=Day(DateAdd(Month, 1, @date) - Day(DateAdd(Month, 1, @date)))
print @daycount
Posted by Arun.S at 3:16 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Other Blogs

  • Client Report
  • zoomtoreports

Blog Archive

  • ►  2012 (2)
    • ►  May (2)
  • ►  2011 (7)
    • ►  December (1)
    • ►  March (6)
  • ►  2009 (13)
    • ►  November (2)
    • ►  October (2)
    • ►  August (1)
    • ►  June (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (2)
  • ▼  2008 (27)
    • ►  December (3)
    • ►  November (4)
    • ►  October (6)
    • ▼  September (6)
      • Update UpdatePanel Using Javascript
      • Focus Back to that control -C#
      • Allow only numeric values in textbox-Javascript
      • To Find No Of Days in a month -SQL
      • Date Conversion
      • GridView-Row Identification In TemplateField ( Tex...
    • ►  August (4)
    • ►  July (4)

About Me

Arun.S
View my complete profile