Oracle SQL 求助 - to_timestamp問題
CREATE TABLE MANAGERS (EMPLOYEEID INT NOT NULL,
DEPARTMENTID INT NOT NULL,
ALTER_TIMESTAMP TIMESTAMP NOT NULL
);
Insert Into "MANAGERS" (EMPLOYEEID, DEPARTMENTID, ALTER_TIMESTAMP)
VALUES(1, 1, to_timestamp(SYSTIMESTAMP, 'yyyy-MM-dd HH24:MI:ss.ff'));
VALUES那行發生錯誤 ORA-01830: date format picture ends before converting entire input string
VALUES(1, 1, to_timestamp(SYSTIMESTAMP, 'yyyy-MM-dd HH24:MI:ss.ff'));哪裡出問題?
我想插入當前系統的年月日時分秒毫秒
页:
[1]