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.
TimeStamp to Date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
The default date format (for display) can be overridden in the date column's extended properties.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.