https://www.logicwiki.co.uk/index.php?action=history&feed=atom&title=DATEADD%28%29_SQL
DATEADD() SQL - Revision history
2026-06-13T14:19:17Z
Revision history for this page on the wiki
MediaWiki 1.26.2
https://www.logicwiki.co.uk/index.php?title=DATEADD()_SQL&diff=737&oldid=prev
Dt1nh6: 1 revision imported
2016-05-09T13:27:52Z
<p>1 revision imported</p>
<table class='diff diff-contentalign-left'>
<tr style='vertical-align: top;' lang='en'>
<td colspan='1' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='1' style="background-color: white; color:black; text-align: center;">Revision as of 13:27, 9 May 2016</td>
</tr><tr><td colspan='2' style='text-align: center;' lang='en'><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>
Dt1nh6
https://www.logicwiki.co.uk/index.php?title=DATEADD()_SQL&diff=736&oldid=prev
Macrop: Created page with "Category:SQL The DATEADD() function adds or subtracts a specified time interval from a date. {| class="wikitable" border="1" |- ! datepart ! Abbreviation |- | year | yy..."
2015-04-16T09:26:23Z
<p>Created page with "<a href="/index.php?title=Category:SQL&action=edit&redlink=1" class="new" title="Category:SQL (page does not exist)">Category:SQL</a> The DATEADD() function adds or subtracts a specified time interval from a date. {| class="wikitable" border="1" |- ! datepart ! Abbreviation |- | year | yy..."</p>
<p><b>New page</b></p><div>[[Category:SQL]]<br />
<br />
The DATEADD() function adds or subtracts a specified time interval from a date.<br />
<br />
{| class="wikitable" border="1"<br />
|-<br />
! datepart<br />
! Abbreviation<br />
|-<br />
| year <br />
| yy, yyyy<br />
|-<br />
| quarter<br />
| qq, q<br />
|-<br />
| month <br />
| mm, m<br />
|-<br />
| dayofyear<br />
| dy, y<br />
|-<br />
| day<br />
| dd, d<br />
|-<br />
| week <br />
| wk, ww<br />
|-<br />
| weekday <br />
| dw, w<br />
|-<br />
| hour <br />
| hh<br />
|-<br />
| minute <br />
| mi, n<br />
|-<br />
| second <br />
| ss, s<br />
|-<br />
| millisecond <br />
| ms<br />
|-<br />
| microsecond <br />
| mcs<br />
|-<br />
| nanosecond <br />
| ns<br />
|}<br />
<br />
SELECT OrderId,DATEADD(day,45,OrderDate) AS OrderPayDate FROM Orders</div>
Macrop