Dunno where to post this but...
I keep getting error messages come up when im tryin to enter data into tables. It keeps saying
ORA-01861: literal does not match format string
Ive tried google and im guessing its something to do with the date type. Heres the table and input code:
CREATE TABLE client_orders (order_number SMALLINT, order_date DATE, order_time SMALLINT, LCT_staff_number_adm SMALLINT, client_staff_number SMALLINT, discounted_amount NUMERIC (7,2), net_order_total NUMERIC(7,2), vat NUMERIC(7,2), gross_order_total NUMERIC(7,2));
ALTER TABLE client_orders ADD CONSTRAINT on_pk PRIMARY KEY (order_number);
ALTER TABLE client_orders ADD CONSTRAINT co_fk1 FOREIGN KEY (ltc_staff_number_adm) REFERENCES staff(ltc_staff_number);
ALTER TABLE client_orders ADD CONSTRAINT co_fk2 FOREIGN KEY (client_staff_number) REFERENCES clients(client_staff_number);
INSERT INTO client_orders VALUES ('25646', '20070207', '1321', '42456', '36934', '1.22', '20.50', '3.59', '22.87');
Cheers
