Introduction
DATE data may be converted to the following numeric types:
- BYTEINT
- SMALLINT
- INTEGER
- BIGINT
- DECIMAL(n, m)
- NUMBER
- FLOAT
CAST Syntax
CAST ( date_expression AS numeric_data_type [ data_attribute [...] ] )
- date_expression
-
A date 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