Oracle

CREATE TABLE test_timestamp(id NUMBER,a timestamp DEFAULT systimestamp);
INSERT INTO test_timestamp(id) VALUES (1);
commit;