GETDATE is functiona in database which Returns the current database system timestamp as a datetime value without change the database time and value is derived from the operating system of the computer on which the instance of SQL Server is running. The function GETDATE can cause the query to run slowly because the query optimizer is unable to obtain accurate cardinality estimates for the GETDATE value. We recommend that you precompute the GETDATE value.