CONVERT TIMESTAMP TO USER DEFINED DATE FORMAT

[vinodbp]

Dear friends,

source is oracle and target also oracle.
I need to convert timestamp to user defined date format


Please suggest me to how to over come this problem

Thanks
Vinod

[ArndW]

Oracle Date and Timestamp are not stored with formats. You can choose which display format to use when converting to a string or display output.
What is your actual problem in this case? What format do you need where?