Date representation

mgupta · #1 (**permalink**) 11-20-03, 15:39

Wer are on AIX 4.33, UDB 7.2 Fixpack 10.

When I select a date field thru AIX, it shows in MM/DD/YYYY format.
The same date shows correctly in YYYY-MM-DD format thru Control Center GUI or Quest Central...

what should be changed in AIX to fix this ??

n_i · #2 (**permalink**) 11-20-03, 16:15

Quote:

Originally posted by mgupta
Wer are on AIX 4.33, UDB 7.2 Fixpack 10.

When I select a date field thru AIX, it shows in MM/DD/YYYY format.
The same date shows correctly in YYYY-MM-DD format thru Control Center GUI or Quest Central...

what should be changed in AIX to fix this ??

As far as I understand the date is formatted by default using the database locale setting. You can use CHAR(date_field, ISO) to ensure consistent formatting.

mgupta · #3 (**permalink**) 11-20-03, 16:22

the CHAR(date_field, ISO) does show it in ISO so it helps.

But how can I set the database locale setting or somewhere in db2set to make this permanent...

thanks again

n_i · #4 (**permalink**) 11-20-03, 17:07

Quote:

Originally posted by mgupta
the CHAR(date_field, ISO) does show it in ISO so it helps.

But how can I set the database locale setting or somewhere in db2set to make this permanent...

thanks again

I believe you have to specify the necessary locale at the database creation time:

CREATE DATABASE ... USING CODESET ... TERRITORY ...

Internet Services

Web Development

Digital Marketing

Consumer Tech