Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

Select CONVERT(varchar,GETDATE(),114) hh

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