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!

ODI: Mapping SQL Server datetime to ORACLE Date field

2773539Oct 14 2014 — edited Oct 21 2014

Hi,

I trying to map a datetime field (SQL Server) to a Date field in my Oracle DB staging table.

The format in source (SQL Server) is 2014-08-12 15:04:48.927 and in the mapping for the staging table i am using the function TO_TIMESTAMP(sql_field_name, 'YYYY-MM-DD HH24:MI:SS.ff')

When executing the interface it fails with the error: ORA-01843: not a valid month

Is there an error in the conversion?

Any help will be appreciated.

Thanks.

This post has been answered by 2773539 on Oct 21 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2014

Added on Oct 14 2014

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

4 comments

4,326 views