Mega Code Archive
Categories
/
MSSQL Tutorial
/
Date Functions
CONVERT(varchar,GETDATE(),113) dd Mmm yyyy hh
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>