Date and Time Functions
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 |
See Also
'
Comments (
)
)
Link to this page:
//www.vb-net.com/Sql/Sql/Ts_fa-fz_2c1f.htm
|
|