| title | Interval Escape Sequences | 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 |
|
|||
| ms.assetid | 303e8dab-8f13-4fa5-857f-15cc1f75bdd6 | |||
| author | David-Engel | |||
| ms.author | v-daenge |
ODBC uses escape sequences for interval literals. The syntax of this escape sequence is as follows:
{interval-literal}
For the BNF syntax of interval-literal, see the Interval Literal Syntax section later in this appendix.
The interval literal escape sequence is supported if the interval data types are supported by the data source. An application should call SQLGetTypeInfo to determine whether these data types are supported.