Converting VarChar into Oracle Timestamp (Date)

Childrensmn · Post by **Childrensmn** » Wed Mar 18, 2015 10:24 am

I have "NewDate" column coming from SQL Server as VarChar with the following format:
MM/DD/YYYY HH:MI
6/14/2014 16:07

I want to load this into Oracle table using Timestamp datatype (Its Date in Oracle).

Any pointers/help is appreciated.

Thanks!!

AshishDevassy · Post by **AshishDevassy** » Wed Mar 18, 2015 10:41 am

If its 'MM'/DD/YYY HH:MI shouldn't the data be 06.14.2014 16:07 ?

Childrensmn · Post by **Childrensmn** » Wed Mar 18, 2015 10:55 am

Here is how the data for that column is
6/14/2014 16:07
and
I want to load it in Oracle as Timestamp (Date) 'YYYY-MM-DD HH24:MI:SS'

AshishDevassy · Post by **AshishDevassy** » Wed Mar 18, 2015 12:32 pm

alright.
Here's what you can try.
Read the data as varchar. Use transformer to extract the data before the ' ' and then use type conversion function to change it to date.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 18, 2015 3:11 pm

Research format strings, in particular how to accommodate elements that have a variable number of characters (for example your month and day components may have one or two digits).

taylor.hermann · Post by **taylor.hermann** » Thu Mar 19, 2015 7:23 am

I'd try researching the StringToTimestamp function available. It sounds like it may fit your needs