Mega Code Archive

 

Categories / Oracle PLSQL / Conversion Functions

 

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