Hai Buddy's This is the way to convert date format in 'dd-mm-yyyy'...follow the below syntax.

In the db2 query:db2 "REPLACE(CHAR(D ATE,EUR),'.','-')".THEN EXECUTE THE PROGRAM...YOU GET THE 'DD-MM-YYYY' FORMAT.



from Rameshnaidu G.