Sathya Sathya - 1 month ago 9
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


or


23-DEC-2008 00:00:00


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

Answer

I assume you're using insert statements?

Convert your dates using:

TO\_DATE(sql\_server\_value,'YYYY.MM.DD HH24:MI:SS')