• Login

DataSoft Corporation

DATEADD (datepart, interval, date_exp)

Returns a new DATETIME value based on adding an interval to a date. For example, a datapart day, an interval of 11, and a date_exp of January 26, 2020, returns February 6, 2020.

Datepart specifies the part of the date to which interval is added, and must be one of the following values.

year
quarter
month
day
dayofyear
week
hour
minute
second
millisecond

Interval specifies a positive or negative integer value used to increment datepart. If interval contains a fractional portion, the fraction part is ignored.

Date_exp is an expression that returns a DATETIME value, a value that can be implicitly converted to a DATETIME value, or a character string in a DATE format

Thursday, 18 April 2019 Posted in Time and Date Functions
 DataSoft Store  Knowledgebase  Contact Us
 Sitemap  Privacy Policy
    Customer Service


Copyright © 2019 DataSoft Corporation All rights reserved.