SQL Notebook (logo)

DATEADD Function

Returns a new date by adding a specified time interval to an existing date.

Syntax

DATEADD(date-part, number, date)

Arguments

Return Value

A date/time with time zone offset (i.e. a string like "2016-07-23 21:13:23.350 -04:00"), calculated by adding number to the part of date that is specified by date-part.

Examples