View source for DATEADD() SQL

[[Category:SQL]]

The DATEADD() function adds or subtracts a specified time interval from a date.

{| class="wikitable" border="1"
|-
! datepart
! Abbreviation
|-
| 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
|-
| microsecond		
| mcs
|-
| nanosecond	
| ns
|}
 
 SELECT OrderId,DATEADD(day,45,OrderDate) AS OrderPayDate FROM Orders