| title |
Date Arithmetic | Microsoft Docs |
| ms.custom |
|
| ms.date |
01/19/2017 |
| ms.prod |
sql-non-specified |
| ms.reviewer |
|
| ms.suite |
|
| ms.technology |
|
| ms.tgt_pltfrm |
|
| ms.topic |
article |
| helpviewer_keywords |
date arithmetic [ODBC] |
SQL grammar [ODBC], date arithmetic |
|
| ms.assetid |
538b274a-822e-4126-993e-7d9a92c6a7d9 |
| caps.latest.revision |
6 |
| author |
MightyPen |
| ms.author |
genemi |
| manager |
jhubbard |
The driver supports adding and subtracting an integer from a DATE, TIME, or TIMESTAMP column. For a DATE column, the integer specifies the number of days to add or subtract. For a TIME or TIMESTAMP column, the integer specifies the number of seconds to add or subtract.