Skip to Main Content
Forums

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!

ora-01847 error (day of month must be between 1 and last day of month)

941976Jun 14 2012 — edited Jun 14 2012
Hi

Executng the below query, I am getting error ora-01847
   INSERT INTO SVC_ORDER
      (DUE_DATE)                    
       SELECT to_date(lpad(decode(O.SVC_ORD_DT_REQ,999999,null,O.SVC_ORD_DT_REQ),6,'0'),'rrmmdd') AS DUE_DT
              FROM M04_NT_UV_ORD_ADMIN O
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2012
Added on Jun 14 2012
13 comments
4,295 views