I’m running a simple query against a DB2 (z/OS) database (using TDP 3.2) and regardless of what date format I choose in the “Data Type Formatting” area (under Options - Environment - Grid), dates are returned in the DD/MM/YYYY format. I tried selecting built-in formats (such as “Short date pattern (d)”) and custom formats (like yyyy-MM-dd) to no avail. The same functionality is working fine when querying an Oracle DB. Any suggestions would be much appreciated…
Thanks,
Edgar