Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

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

3>  select CONVERT(varchar,GETDATE(),108) 'hh:mm:ss' 4> GO hh:mm:ss ------------------------------ 13:13:00 (1 rows affected)