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.