TimeStamp to Date

dsdev_123 · Post by **dsdev_123** » Wed Jan 23, 2008 2:12 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 23, 2008 7:51 pm

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.

dsdev_123 · Post by **dsdev_123** » Thu Jan 24, 2008 12:33 pm

thanks ray.that solved my problem.