Hi,

We are porting Oracle9i database into DB2 UDB v8.1.We have TIMESTAMP filed in our tables and need it's output in various formats(the way oracle provides thru it's to_char() function eg: mm/dd/yyyy or yyyy/mm/dd).But in DB2 we face the following problem while trying various options :
1. The use of CHAR function for desired formats is restricted to DATE type data only. With TIMESTAMP data type , we can not provide the format, the way we want ! And as mentioned above, we have TIMESTAMP filed in database.

2.The inbuilt DB2 function TO_CHAR() or VARCHAR_FORMAT() supports only ’YYYY-MM-DD HH24:MIS’.

3.We have also tried UDF for TO_CHAR [available on net thru IBM] . But on a system running multiple applications, this function goes too slow and finally database connection breaks. So lost here onwards!

Can you please suggest some work around/solutions.
Looking for a positive response.
Thanks and regards,
Raj Shekhar