Date Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Date Functions
  4. 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)