These scalar functions perform an operation on a date and time input value and return a string, numeric, or date and time value.
This table lists the date and time functions and their determinism property. For more information about function determinism, see Deterministic and Nondeterministic Functions.
| Function | Determinism |
|---|---|
| DATEADD | Deterministic |
| DATEDIFF | Deterministic |
| DATENAME | Nondeterministic |
| DATEPART | Deterministic except when used as DATEPART (dw, date). dw, the weekday datepart, depends on the value set by SET DATEFIRST, which sets the first day of the week. |
| DAY | Deterministic |
| GETDATE | Nondeterministic |
| GETUTCDATE | Nondeterministic |
| MONTH | Deterministic |
| YEAR | Deterministic |