INTERVAL-to-Numeric Conversion | Data Types and Literals | Teradata Vantage - INTERVAL-to-Numeric Conversion - Advanced SQL Engine - Teradata Database

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zsn1556242031050.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantageā„¢

Convert an INTERVAL with only one field to an exact numeric data type.

This numeric value is the value of the single numeric field in the INTERVAL record.

CAST Syntax

CAST (
  interval_expression AS numeric_data_type
  [ data_attribute [...] ]
)
interval_expression

An INTERVAL expression to be converted.

numeric_data_type

The data type to which the expression is to be converted.

data_attribute
One of the following data attributes:
  • FORMAT
  • NAMED
  • TITLE