Oracle date format picture ends before converting entire input string

Question

My table has two DATE format attributes  however  when i try to insert value it throws an error  date format picture ends before converting entire input string  Here is my attempted code   insert into visit values 123456   19-JUN-13    13-AUG-13 12 56 A M       I think the problem is with 12 56 but Oracle documentation says date implies both date and time

User · Answer

you need to alter session  you can try before insert   sql   alter session set nls date format    YYYY-MM-DD HH24 MI SS

User · Answer

What you re trying to insert is not a date  I think  but a string  You need to use to date   function  like this   insert into table t1  id  date field  values  1  to date  20 06 2013    dd mm yyyy

User · Answer

Perhaps you should check NLS DATE FORMAT and use the date string conforming the format  Or you can use to date function within the INSERT statement  like the following   insert into visit values 123456          to date  19-JUN-13    dd-mon-yy           to date  13-AUG-13 12 56 A M     dd-mon-yyyy hh mi A M        Additionally  Oracle DATE stores date and time information together

User · Answer

I had this error today and discovered it was an incorrectly-formatted year      select   from es timeexpense where parsedate  gt  to date  12 3 2018    MM dd yyy     Notice the year has only three  y s  It should have 4   Double-check your format

[oracle] Oracle date format picture ends before converting entire input string

Examples related to oracle

Examples related to date

Examples related to time