4> select CONVERT(varchar,GETDATE(),114) 'hh:mm:ss:mmm' 5> GO hh:mm:ss:mmm ------------------------------ 13:13:00:570 (1 rows affected)