Dateadd sql server

broken image
broken image

DATEADD will truncate a specified number value that has a decimal fraction.

broken image

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.