Mega Code Archive

 
Categories / Oracle PLSQL / Conversion Functions
 

Cast null as timestamp

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