Date time functions performs an operation on a date and time input values. It returns a string, numeric or date time value.

 

Below are the available date time functions available in sql server with its determinism. It can be either deterministic means always return the same result any time they are called with a specific set of input values or nondeterministic means return different results each time they are called with a specific set of input values.