Oracle Date and/or Time in Seconds

This page answers questions like these:

Get the Date and/or Time in Oracle:

SELECT SYSDATE FROM DUAL;

Store the Oracle Date and/or Time in Seconds:

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

See the Oracle Date and/or Time in Seconds:

SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY HH24:MI:SS') FROM mytable;
Related Links:
Oracle Time in Microseconds
What Oracle Version do I Have?
Defragment Tablespace

Home  >  Oracle  >  Oracle Date and/or Time in Seconds


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

Src: oracle-date-time.txt
Dst: Oracle/date-time-in-seconds.htm
Ads: 4