CREATE TABLE INVOICE_TEST
(INVOICE_NO NUMBER (5),
INVOICE_DATE DATE, ‘MM/DD/YYYY’,
CUSTOMER _ID NUMBER (5),
QTY NUMBER (6),
NET_SALES NUMBER (6));
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
insert into invoice_test (invoice_date) values (:x); -- this is a bind variable of type DATE
insert into invoice_test(invoice_date)
insert into invoice_test(invoice_date)
insert into invoice_test(invoice_date)
insert into invoice_test(invoice_date)
internally the date are stored as 7 bytes and don't look anything like the text representations I've used above.