Cast null as timestamp : CAST « Conversion Functions « Oracle PL / SQL






Cast null as timestamp

  

SQL> SELECT CAST(NULL AS TIMESTAMP WITH LOCAL TIME ZONE) from dual;

CAST(NULLASTIMESTAMPWITHLOCALTIMEZONE)
---------------------------------------------------------------------------

   
    
  








Related examples in the same category

1.CAST() convertS one built-in data type (cast) into another
2.Cast string to date type before comparison
3.cast(12.98 as number(2))
4.cast(null as date )