How To Populate a Timestamp Field With Current Timestamp

Raw:

SELECT SYSTIMESTAMP AS TSTAMP FROM DUAL;

Formatted:

SELECT TO_CHAR(SYSTIMESTAMP, 'DD/MM/YYYY HH24:MI:SS.FF6') AS TSTAMP FROM DUAL;

Populating a timestamp database field using a current timestamp:

INSERT INTO TABLE_NAME(TSTAMP) VALUES ((SELECT SYSTIMESTAMP FROM DUAL));

Or another way is simply to use TO_TIMESTAMP() if the timestamp time is known:

INSERT INTO TABLE_NAME(TSTAMP) VALUES (
   TO_TIMESTAMP('3/08/2010 4:38:52.000000 PM','fmDDfm/MM/YYYY fmHH12fm:MI:SS.FF AM')
);