Sathya Sathya - 1 year ago 131
SQL Question

How can I convert a SQL Server date format to Oracle?

I am working on migration of data from an old system to a new system. As part of migration, the data from the legacy system, (stored in files) is pumped into MS SQL Server. Now my app runs on Oracle. I'm having a problem with the date/timestamp.

The timestamp format in MS SQL Server data is:

2008.12.23 00:00:00

Oracle expects:

23/12/2008 00:00:00


23-DEC-2008 00:00:00

What would be the best way to import the data? Oracle's
function didn't work as I thought it would.

Answer Source

I assume you're using insert statements?

Convert your dates using:

TO\_DATE(sql\_server\_value,'YYYY.MM.DD HH24:MI:SS')
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download