Numeric-to-INTERVAL Conversion
Purpose
Convert numeric data to an INTERVAL value with a single DateTime field.
CAST Syntax
where:
Syntax element … |
Specifies … |
numeric_expression |
an expression or existing field having a numeric data type. |
interval_data_type |
the target INTERVAL data type to which the numeric expression is being converted. |
interval_data_attribute |
one of the following optional data attributes: |
ANSI Compliance
This is ANSI SQL:2011 compliant.
As an extension to ANSI, CAST permits the use of interval data attribute phrases.
Teradata Conversion Syntax
where:
Syntax element … |
Specifies … |
numeric_expression |
an expression or existing field having a numeric data type. |
data_attribute |
one of the following optional data attributes: |
interval_data_type |
the target INTERVAL data type to which the numeric expression is being converted. |
ANSI Compliance
This is a Teradata extension to the ANSI SQL:2011 standard.
Usage Notes
Numeric data is converted to an INTERVAL value with a single DateTime field.
If the numeric value is in the value range allowed for the INTERVAL, the value is used as the single field of the INTERVAL. Otherwise, an overflow error is returned.
Implicit Numeric-to-INTERVAL Conversion
Teradata Database performs implicit conversion of an exact numeric data type to an Interval data type in some cases. See “Implicit Conversion of DateTime types” on page 586.
Example
The following query returns ' -5' (with three leading pad characters).
SELECT CAST(-5 AS INTERVAL YEAR(4));
Related Topics
For details on data types and data attributes, see SQL Data Types and Literals.