Error: date format pictures end before converting entire input string.

See more:

Oracle

While I am importing data from csv file to Oracle DB table , I am facing "date format pictures end before converting entire input string. " error.Below is my insert command

Insert into tbl_ivr_summenuhits_3(DateTime,LocationId,ParentMenu,MemuId,TotalHits)
values (to_date('21-Aug-2017 12:00:00 AM 'dd-mon-yyyy'),'MUM','Credit-Card_MM_Dn','Block_Dn',2.0);

In the CSV file DateTime column datatype is Date .

What I have tried:

Rightclick on Table->Next->Generate insert script->Next->Checked all the columnName-> formt DD-MM-YYYY->Verify(Success)->finish.

Also I tried
Alter session set NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';