Transact-SQL statements can refer to GETDATE anywhere they can refer to a ... The following examples use the six SQL Server system functions that return ...
technet.microsoft.com