SELECT CAST(NULL AS TIMESTAMP WITH LOCAL TIME ZONE) from dual; : ROWIDTONCHAR « Conversion Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Conversion Functions
  3. ROWIDTONCHAR
CAST(NULLASTIMESTAMPWITHLOCALTIMEZONE)
---------------------------------------------------------------------------
15.6.ROWIDTONCHAR
15.6.1.ROWIDTONCHAR(x): Converts the ROWID x to an NVARCHAR2 character.
15.6.2.SELECT CAST(NULL AS TIMESTAMP WITH LOCAL TIME ZONE) from dual;