[分享]orecle 要新增datatype為date的資料的方式
用TO_DATE('1998/05/31 11:3:26' , 'YYYY/MM/DD HH:MI:SS')
或者TO_DATE('1998/05/31' , 'YYYY/MM/DD')
範例:
CREATE TABLE Appraisal(
rId CHAR(12) NOT NULL,
seq CHAR(12) NOT NULL,
alevel INT default 0,
aTime TIMESTAMP,
PRIMARY KEY(rId,seq),
FOREIGN KEY(rId) REFERENCES Rest(rId)
ON DELETE CASCADE
);
INSERT INTO Appraisal
VALUES('wang', Seq_MarsTest.NEXTVAL ,5,
TO_DATE('1998/05/31 11:3:26','YYYY/MM/DD HH:MI:SS') )
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.117.76.89