Master: An Oracle date insertion problem? Please advise! Help, thank you for the author: HE_HAWK (strong) level: credit value: 100 community: .NET technology C # problem points: 20 Reply number: 3 Posted: 2004-9-13 18:25:19
Table field
Name varcha2 (10) characters
Addtime Date Date
Now achieve the following code:
INSERT INTO TABLE_A (Name, ADDTIME) VALUES ('A5DB09', '2004-9-13 17:47:34')
How should I write?
The above code is not correct in SQLPLUS.
That date field.
INSERT INTO TABLE_A (Name, ADDTIME) VALUES ('A5DB09', SYSDATE)
It can be performed.
Thank you!!
Reply to: Klmy (Karamay) () Reputation: 98 2004-9-13 18:48:23 Score: 10
INSERT INTO TABLE_A (Name, ADDTIME) VALUES ('A5DB09', TO_DATE ('2004-9-13 17:47:34 ",' YYYY-MM-DD HH: MM: SS ')
TOP
Reply to: JZPONE (Rebel) () Reputation: 100 2004-9-13 18:48:43 Score: 10
INSERT INTO TABLE_A (Name, ADDTIME) VALUES ('A5DB09', TO_DATE ('2004-9-13 17:47:34 ",' YYYY-MM-DD HH24: MI: SS ')
TOP
Reply to: He_hawk (strong) () Reputation: 100 2004-9-14 12:44:28 Score: 0
Thank you
TOP
