INTERVAL SECOND Range of Values - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

The range of values for INTERVAL SECOND is as follows.

Type, Precision, and Fractional Seconds Precision Minimum Value Maximum Value
INTERVAL SECOND(1,0) -'9' '9'
INTERVAL SECOND(1,1) -'9.9' '9.9'
INTERVAL SECOND(1,2) -'9.99' '9.99'
INTERVAL SECOND(1,3) -'9.999' '9.999'
INTERVAL SECOND(1,4) -'9.9999' '9.9999'
INTERVAL SECOND(1,5) -'9.99999' '9.99999'
INTERVAL SECOND(1,6) -'9.999999' '9.999999'
INTERVAL SECOND(2,0) -'99' '99'
INTERVAL SECOND(2,1) -'99.9' '99.9'
INTERVAL SECOND(2,2) -'99.99' '99.99'
INTERVAL SECOND(2,3) -'99.999' '99.999'
INTERVAL SECOND(2,4) -'99.9999' '99.9999'
INTERVAL SECOND(2,5) -'99.99999' '99.99999'
INTERVAL SECOND(2,6) -'99.999999' '99.999999'
INTERVAL SECOND(3,0) -'999' '999'
INTERVAL SECOND(3,1) -'999.9' '999.9'
INTERVAL SECOND(3,2) -'999.99' '999.99'
INTERVAL SECOND(3,3) -'999.999' '999.999'
INTERVAL SECOND(3,4) -'999.9999' '999.9999'
INTERVAL SECOND(3,5) -'999.99999' '999.99999'
INTERVAL SECOND(3,6) -'999.999999' '999.999999'
INTERVAL SECOND(4,0) -'9999' '9999'
INTERVAL SECOND(4,1) -'9999.9' '9999.9'
INTERVAL SECOND(4,2) -'9999.99' '9999.99'
INTERVAL SECOND(4,3) -'9999.999' '9999.999'
INTERVAL SECOND(4,4) -'9999.9999' '9999.9999'
INTERVAL SECOND(4,5) -'9999.99999' '9999.99999'
INTERVAL SECOND(4,6) -'9999.999999' '9999.999999'