Info-lake
Knowledge sharing....
June 27, 2012
Start Date and End date of the month
SELECT Convert(datetime , CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(Getdate())-1), Getdate() ),103),103) AS Date_Value
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))Declare @FromDate datetime
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment