Date Functions MSSQL Tutorial

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