how to change the date format 1

[123Hai]

Hi,

I am getting date from DB2 table in java result set as yyyy/mm/dd .I want to show it as dd/mm/yyyy or mm/dd/yyyy . What is the command for that...

Regards,
Sriram

 

[MarcLodge]

Hi sriram,
Issuing the following SQL:

SELECT CHAR(CURRENT DATE,ISO)
,CHAR(CURRENT DATE,USA)
,CHAR(CURRENT DATE,EUR)
,CHAR(CURRENT DATE,JIS)
FROM SYSIBM.SYSDUMMY1

returns:

COL1 COL2 COL3 COL4
---------- ---------- ---------- ----------
2002-12-30 12/30/2002 30.12.2002 2002-12-30

I also think there's a local option that is defined by your DB2 admin people.
Hope this helps.
Marc