Page 1 of 1

date conversion

Posted: Thu Sep 18, 2008 4:56 am
by krisna
Hi,

I have input in a .csv file as dd/mm/yyyy, output is oracle table datatype is date output should be yyyy-mm-dd.

Posted: Thu Sep 18, 2008 7:13 am
by ray.wurlod
Thank you for sharing that.

Most of those here who use Oracle are aware of the default date format picture.

Posted: Fri Sep 19, 2008 10:45 pm
by ambasta
Read the source metadata as varchar the use String to Date format in the transformer