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
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
No comments:
Post a Comment