17.20 - Interval Values - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

Both TIMESTAMPADD( ) and TIMESTAMPDIFF( ) support the interval values listed in the following table.

Interval Values
SQL_TSI_FRAC_SECOND SQL_TSI_DAY
SQL_TSI_SECOND SQL_TSI_MONTH
SQL_TSI_MINUTE SQL_TSI_YEAR
SQL_TSI_HOUR