select CONVERT(varchar,GETDATE(),114) 'hh:mm:ss:mmm' : GETDATE « Date Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Date Functions
  3. GETDATE
4> select CONVERT(varchar,GETDATE(),114) 'hh:mm:ss:mmm'
5> GO
hh:mm:ss:mmm
------------------------------
13:13:00:570

(1 rows affected)








10.10.GETDATE
10.10.1.GETDATE function returns the current system date and time of the server.
10.10.2.SELECT GETDATE() + 14
10.10.3.Select GETDATE()
10.10.4.Use GetDate() function in where clause
10.10.5.select CONVERT(varchar,GETDATE(),108) 'hh:mm:ss'
10.10.6.select CONVERT(varchar,GETDATE(),114) 'hh:mm:ss:mmm'
10.10.7.CONVERT(varchar,GETDATE(),113) 'dd Mmm yyyy hh:mm:ss:mmm'