VistaDB 5
DATEADD
DATEADD( datepart, number, date )

Returns a new datetime based on adding to the date passed to the function.

The following are valid datepart parameters:

Datepart Abbreviations
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
weekday dw, w
hour hh
minute mi, n
second ss, s
millisecond ms

SQL Server Difference

SQL Server will actually accept the parameters out of order when they are passed from other functions. VistaDB does not support this behavior of SQL Server.

You also cannot pass 0 as a value for a DATETIME. .Net does not cast a 0 to the minimum date range available.


Remarks

Note that the adding of things like month to another month is smart enough to take into account the number of days in a month.

SELECT DATEADD(month, 1, '08/30/2007') SELECT DATEADD(month, 1, '08/31/2007')

Both of these will return: 9/30/2007 12:00:00 AM (The end of September).


Example

Output:  1/1/2001 12:00:00 AM

Output:  1/1/2001 12:00:00 AM

Output:  7/15/2007 12:00:00 AM
SELECT DATEADD(quarter, 1, '04/15/2007')
SELECT DATEADD(yy, 1, '01/1/2000')
SELECT DATEADD(year, 1, '01/1/2000')
See Also