CAST() convertS one built-in data type (cast) into another : CAST « Conversion Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Conversion Functions
  3. CAST

CAST() convertS one built-in data type (cast) into another

   

SQL>
Syntax: CAST(<expression> | [(subquery)] | [MULTISET (subquery)] AS type_name)
SQL>
SQL> SELECT CAST('05-JUN-2004' AS DATE) + 3  threedaysahead
  2  FROM dual;

THREEDAYS
---------
08-JUN-04








Related examples in the same category

1.Cast null as timestamp
2.Cast string to date type before comparison
3.cast(12.98 as number(2))
4.cast(null as date )