DSXchange

My source value is like this : 2007-12-14 00:00:00 (timestamp datatype )

My desired output is : 14/12/2007 (DD/MM/YYYY)format as Date datatype

Here i am extracting the data from Oracle database and loading into oracle database.

I have tried several ways using To_Char and To_Date functions but in vain.

Any help would be immensly appreciated.

Date data types don't have a format - they are binary. The format picture in TimestampToDate must be that of the timestamp.

The default date format (for display) can be overridden in the date column's extended properties.

thanks ray.that solved my problem.