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!

sql server datetime issue - oracle not capturing millisecond of sql server

user10586521Jun 4 2009 — edited Jun 8 2009

Hi everyone ,

Reading from the sql server datetime to oracle time stamp , oracle is not catpuring correctly the milliseconds of oracle , rather its jsut using 0000000 to poulate rather than the correct millisecond .

iahve checked in the topology too that for sql server datetime converted to for oracle is timestamp.

Please suggest where is it making error . its urgent. ?

Thanks

This post has been answered by Cezar Santos on Jun 8 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2009

Added on Jun 4 2009

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

3 comments

1,505 views