| title |
Date Arithmetic | Microsoft Docs |
| ms.custom |
|
| ms.date |
01/19/2017 |
| ms.prod |
sql |
| ms.prod_service |
connectivity |
| ms.reviewer |
|
| ms.technology |
connectivity |
| ms.topic |
conceptual |
| helpviewer_keywords |
date arithmetic [ODBC] |
SQL grammar [ODBC], date arithmetic |
|
| ms.assetid |
538b274a-822e-4126-993e-7d9a92c6a7d9 |
| author |
David-Engel |
| ms.author |
v-daenge |
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.