DB2 Date format to Oracle Date format?

[Sam Drake]

Hi,
I need to convert a DB2 date (or timestamp) to Oracle format (MM/dd/yyyy).
Please suggest the easiest method.
Thnx,
Sam.

[John Ipe]

Hi,
What is the format for the DB2 date? Have you tried using java.text.SimpleDateFormat?
Regards

[Michael Zalewski]

I thought the default Oracle format was DD-MON-YYYY, as in '06-JAN-2004'. I think that's the way dates come out in DB2 also. Actually, I think that is some kind of standard.
Anyway, if you have a string in a particular format, you can convert in Oracle using the TO_DATE and TO_CHAR functions.
For example, if you have a string that looks like '06-JAN-2004', and you want to display a string that looks like '01/06/04', you could
1) Convert the string to a Date with TO_DATE( string, 'DD-MON-YYYY')
2) Convert the Date back to a string with TO_CHAR( date, 'MM/DD/YY')
Putting it all together, it looks like this:

SELECT TO_CHAR( 
    TO_DATE( '06-JAN-2004', 'DD-MON-YYYY')
  , 'MM/DD/YY'
) FROM DUAL;

[Gustavo Adolpho Bonesso]

I agree with John, use the method format, in class java.text.SimpleDateFormat to format de java.sql.Date object that you extract from ResultSet.