SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data type to receive date, time, and am/pm values

983742a2-e96b-406a-b76d-86da6b94496bApr 10 2016 — edited Apr 11 2016

I have created shipment table, and an attribute of the shipment table is 'ship_date'. I have to insert thousands of rows of data for this table, all in the form:

insert into cmShipment (shipment_#, cust_id, weight, truck_#, destination, ship_date) values( 1000 , 1284 , 1.02 , 27 ,'Dallas', 7/5/1966' 3:57:00' PM );

My problem is that i do not know what data type should be used for 'ship_date' that will accept the date, time, and AM/PM in that form.

any help would be greatly appreciated

thanks!

note: the INSERT statements were predetermined and cannot be altered.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2016

Added on Apr 10 2016

6 comments

555 views