---
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
---
# Date Arithmetic
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.