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






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

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 )