Posted by: gandharba June 14, 2017
sql question
Login in to Rate this Post:     0       ?        
Not sure I get your question but I suggest you try using to_date function as shown below.
What error are you getting?

INSERT INTO INVOICE_t (Invoice_Number, Date, VIN_Number, Customer_ID)
VALUES (3456, to_date ('03/20/2016’,'mm/dd/yyyy'), ‘1234567’, ‘1’);
Read Full Discussion Thread for this article