3> SELECT TOP 1 GETDATE() 'Default',
4> CONVERT(varchar,GETDATE(),108) 'hh:mm:ss',
5> CONVERT(varchar,GETDATE(),114) 'hh:mm:ss:mmm',
6> CONVERT(varchar,GETDATE(),113) 'dd Mmm yyyy hh:mm:ss:mmm'
7> GO
Default hh:mm:ss hh:mm:ss:mmm dd Mmm yyyy hh:mm:ss:mmm
----------------------- ------------------------------ ------------------------------ ------------------------------
2006-10-12 07:15:07.950 07:15:07 07:15:07:950 12 Oct 2006 07:15:07:950
(1 rows affected)