Unanswered: Specific date formats in Db2 (Oracle to DB2 porting blues)
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,