Code: Select all
create table ts_test (col1 timestamp(0));
insert into ts_test select systimestamp from dual;
commit;
9/19/2017 3:19:21. PM
notice the dot after the seconds. Can this be removed?
Code: Select all
create table ts_test (col1 timestamp(0));
insert into ts_test select systimestamp from dual;
commit;