3> select CONVERT(varchar,GETDATE(),113) 'dd Mmm yyyy hh:mm:ss:mmm' 4> GO dd Mmm yyyy hh:mm:ss:mmm ------------------------------ 17 Aug 2008 13:13:00:710 (1 rows affected) 1>