Monday, 25 June 2012

Drop Time in DateTime-SQL


SELECT DATEADD(dd, DATEDIFF(d, 0, Getdate()), 0)

Result
2012-06-25 00:00:00.000
Posted by Hema at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)