Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    93

    Unanswered: Date representation

    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 ??

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Date representation

    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.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2003
    Posts
    93
    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

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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 ...
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •