Converts a character string to an interval value.
CAST Syntax
CAST ( character_expression AS interval_data_type [ data_attribute [...] ] )
- character_expression
-
A character expression to be converted.
- interval_data_type
-
An INTERVAL data type to which the expression is to be converted.
- data_attribute
- One of the following data attributes:
- NAMED
- TITLE