I am creating a new table in the GUI and making a TIMESTAMP(6) data type. For that column I would like to put the LOCALTIMESTAMP function in the default column section. But applying the changes I will receive the following error:
Error: ORA-01858: a non-numeric character was found where a numeric was expected
,
I then tried to run the a SQL script to create the table with the LOCALTIMESTAMP, but the Default column is completely blank.
,
CREATE TABLE Date_Test
(log_level VARCHAR2(255 BYTE),
logger VARCHAR2(255 BYTE),
message VARCHAR2(4000 BYTE),
insert_datetime TIMESTAMP (6) DEFAULT LOCALTIMESTAMP);
,
Trying to add the LOCALTIMESTAMP in the Default afterwards, causes the same error.