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>