Interval Values - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
smj1488824663219.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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

Interval Values 
Interval Values
SQL_TSI_FRAC_SECOND SQL_TSI_DAY
SQL_TSI_SECOND SQL_TSI_MONTH
SQL_TSI_MINUTE SQL_TSI_YEAR
SQL_TSI_HOUR