Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Declaring TIMESTAMP Datatype

SQL> SQL> declare   2      v_ts TIMESTAMP(6):=systimestamp;   3      v_tx VARCHAR2(2000);   4  begin   5      v_tx:=to_char(v_ts,'HH24:MI:SS.FF6');   6      DBMS_OUTPUT.put_line(v_tx);   7  end;   8  / 20:32:41.593000 PL/SQL procedure successfully completed. SQL>