Neoview SQL Reference Manual (R2.3)

num_expr
is an SQL exact numeric value expression that specifies how many datepart units of time
are to be added to datetime_expr. If num_expr has a fractional portion, it is ignored. If
num_expr is negative, the return value precedes datetime_expr by the specified amount
of time. See “Numeric Value Expressions” (page 227).
datetime_expr
is an expression that evaluates to a datetime value of type DATE or TIMESTAMP. The type
of the datetime_expression is returned, unless the interval_expression contains
any time components, then a timestamp is returned. See “Datetime Value Expressions”
(page 220).
Examples of DATEADD
• This function adds seven days to the date specified in start_date
DATEADD(DAY, 7,start_date)
• This function returns the value DATE '2001-03-07'
DATEADD(DAY, 7 , DATE '2001-02-28')
• This function returns the value DATE '2000-03-06'
DATEADD(DAY, 7, DATE '2000-02-28')
• This function returns the timestamp '2004-03-07 00:00:00'
DATEADD(DAY, 7, timestamp'2004-02-29 00:00:00')
DATEADD Function 331