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. |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.|