Oracle Time in Microseconds

This page answers questions like these:


Related Links:
Oracle Date and/or Time in Seconds
Defragment Tablespace
What Oracle Version do I Have?
INSERT INTO ... SELECT * FROM ...
Oracle Trigger Compilation Warnings/Errors



Get the Oracle Time in Microseconds:

SELECT SYSTIMESTAMP FROM DUAL;

Store the Oracle Time in Microseconds:

CREATE TABLE mytable ( TIMESTAMP(9) mydatetime, VARCHAR2(30) mycomment ); INSERT INTO mytable VALUES (SYSTIMESTAMP, "This is the time that I ran the insert statement.");

See the Oracle Time in Microseconds:

SELECT TO_CHAR(SYSTIMESTAMP, 'DD-MM-YYYY HH24:MI:SSXFF') FROM mytable;


Related Links:
Oracle Date and/or Time in Seconds
Defragment Tablespace
What Oracle Version do I Have?
INSERT INTO ... SELECT * FROM ...
Oracle Trigger Compilation Warnings/Errors

Home  >  Oracle  >  Oracle Time in Microseconds


Tags: oracle time in microseconds, time, microseconds, sub-second time, subsecond time, sub-second resolution, subsecond resolution, sub-second accuracy, subsecond accuracy, oracle database, oracle, database

Copyright © HelpDoco.com
oracle-microseconds.txt
Oracle/time-in-microseconds.htm
3