Good afternoon;
I Power 740
I AIX 6.1.9
I EGL 9.5.1
I Db2 10.5
I have a problem when I access through the Select to any table containing Date column through my database Perspective Db2 10.5. with my EGL 9.5.1
The problem is that these columns Date me is displayed in ISO format. These Date columns are set on my Db2 database in EUR format.
I need this Columns Date me are presented in EUR Format (Day Month Year).
I have to correct this way as me is presented the Date coluns in my database perspective ????

Note: In my tool Data Studio is also presented me the Dates column in ISO Year Day Month format.
I am doing research on this subject but it seems through the confusing information about it.
I need to research more directly tell me about it.
Can anyone help us ????

Where can I find more specific issue about it ????
 

Example:

DATE_PEDIDO    DATE_SIT       DATE_EMB_TOTAL
 
 2013-01-14         2013-02-02    2013-02-02
 2013-01-14         2013-01-23    2013-01-23
 2013-01-14         2013-02-27    2013-02-27
 2013-01-14         2013-01-25    2013-01-23
 2013-01-24         2013-01-25    2013-01-25
 2013-01-24         2013-04-24    2013-04-24
 2013-01-24         2013-01-28    2013-01-28
 2013-01-28         2013-02-02    2013-02-02

I have to redo some configuration for this ???
 
Thank you
Jose Roberto

Hi Jose,

Did you check the properties of your JDBC connection in which you have been executing your SQL statements?

In your case date format should be set to EUR.

Kind regards,

Guus

Ok gweis;
Thank you for the tip.
Worked perfectly.
Our problem was the lack of parameters in Drivejdbc: DB2 regarding Timestamp and Dateformat.
Now all ok.
Thank you