GETDATE is a nondeterministic function. Views and expressions that reference this column cannot be indexed.

Date functions can be used in the SELECT statement select list or in the WHERE clause of a query.

In designing a report, GETDATE can be used to print the current date and time every time that the report is produced. GETDATE is also useful for tracking activity, such as logging the time a transaction occurred on an account.