DATEADD(<date-expr>,<num_expr day>,<num_expr month>,<num_expr year>)


Returns a DATE that is the result of adding the specified parts to the supplied DATE expression..

PRINT DATEADD(NOW(),1,1,1)

 

See Also: Date And Time Functions


Language Reference  Table Of Contents