Having problem when inserting data in SQL....?
INSERT INTO STOVE
VALUES(StoveIDseq.NEXTVAL, 'FiredNow', TO_DATE('11-May-01','DD-Mon-YY'));
it show error message:invalid month......why???? thx for help =)
More Questions From This User See All
Answers & Comments
Verified answer
where are your columns?
Put MON in capitals
INSERT INTO STOVE VALUES(StoveIDseq.NEXTVAL, 'FiredNow', TO_DATE('11-May-01','DD-MON-YY'));
It's case sensitive.