cast(null as date )
SQL> SQL> select cast(12.98 as number(2)) example1 2 , cast('oak' as char(10) ) example2 3 , cast(null as date ) example3 4 from dual; EXAMPLE1 EXAMPLE2 EXAMPLE3 ---------- ---------- ---------- 13 oak SQL>