If another valid input data type is supplied for date, DATEADD returns the same data type. If the value for date is a string literal date, DATEADD returns a datetime value.

The return type depends on the argument supplied for date. The return value data type for this method is dynamic. See Configure the two digit year cutoff Server Configuration Option for information about two-digit years. Use four-digit years to avoid ambiguity issues. A string literal value must resolve to a datetime. It will not round the number value in this situation.Īn expression that can resolve to one of the following values:įor date, DATEADD will accept a column expression, expression, string literal, or user-defined variable. DATEADD will truncate a specified number value that has a decimal fraction. DATEADD accepts user-defined variable values for number. datepartĪn expression that can resolve to an int that DATEADD adds to a datepart of date.

DATEADD does not accept user-defined variable equivalents for the datepart arguments.

Dateadd sql server