Converts interval data to UDT data.
ANSI Compliance
This statement is ANSI SQL:2011 compliant.
As an extension to ANSI, CAST permits the use of data attribute phrases such as FORMAT.
Syntax
CAST ( interval_expression AS UDT_data_type )
Syntax Elements
- interval_expression
An INTERVAL expression to be converted.
- UDT_data_type
The data type to which the expression is to be converted.