Search This Blog

Wednesday, January 12, 2011

start date & end date Query

select DATEADD(M, DATEDIFF(M, 0, getdate()), 0)
select dateadd (d,-1,dateadd(m,1,DATEADD(M, DATEDIFF(M, 0, getdate()), ),0)))
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)