Hello,

I would like to download a DB2 table using a DSNTIAUL sentence.

The problem is that the dates are being downloaded in format 'DD.MM.YYYY', according to the customization of the DB2 installation.

Is there any parameter to download the dates in the correct format 'YYYY-MM-DD'??

Thank you for your help!

Mark

SELECT CHAR(DATE_COLUMN, ISO) FROM TAB1

This will return the column in ISO format ('YYYY-MM-DD')