5>6>7> SELECT CONVERT(datetime,(CONVERT(varchar,GETDATE(),112)))8> GO-----------------------2008-08-17 00:00:00.000(1 rows affected)