Wednesday, January 4, 2012

Convert datetime with 00 time - sql-server

select cast(convert(char(11), getdate(), 113) as datetime) 

No comments: