ANSI Compliance
This statement is ANSI SQL:2011 compliant.
As an extension to ANSI, CAST permits the use of data attribute phrases.
Syntax
interval_expression ( [ data_attribute, [...] ] numeric_data_type [, data_attribute [,...] ] )
Syntax Elements
- interval_expression
An INTERVAL expression to be converted.
- data_attribute
- One of the following data attributes:
- FORMAT
- NAMED
- TITLE
- numeric_data_type
The data type to which the expression is to be converted.