GETDATE function returns the current system date and time of the server. : GETDATE « Date Functions « SQL Server / T-SQL Tutorial






4>
5> SELECT GETDATE()
6> GO

-----------------------
2008-08-11 21:34:41.793

(1 rows affected)
1>








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'