Analytics Software

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!

Date Conversion to Oracle date

732390Oct 7 2010 — edited Oct 7 2010

I am executing an interface where my source is Execl and target is oracle.
I have a column in Excel where date format is Jan 1 2009 and i need to convert it into yyyy-MM-dd
Can anyone please help me how to do this

I am getting an error while running interface
"com.sunopsis.sql.SnpsQueryException: Parse Exception: value=Jan 1 2009, pattern=yyyy-MM-dd , at byte=01"

Thanks in Advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2010

Added on Oct 7 2010

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

234 views