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!

convert data into Date Format imported from MS SQL Server.

511196Apr 22 2012 — edited Apr 22 2012

I have imported Data from MS SQL Server. The "Date Column" received in number format like 41017.6361109954. How can i convert it into Date in Oracle SQL.

If i import same Data in Excel and change the Column Type to Date. It changes successfully. But in Oracle, I tried To_Date function with different parameters but it didn't work.

Edited by: XAVER on Apr 22, 2012 2:31 AM

This post has been answered by Solomon Yakobson on Apr 22 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2012

Added on Apr 22 2012

10 comments

211 views