shaycullen (12/15/2010)
Yeah, but the question did ask for the "output" - SQL Server will append the 00:00:00.000 onto the end, so technically none of the answers are correct.
SQL Server does nothing in particular (or at least not the server). It's a datetime value, and how it will look on the screen is determined by the client - in this case SQL Server Management Studio.
Nit picking.