Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    10

    Unanswered: Change Command Center output format?

    Does anyone know how to change, say the timestamp format of command center result set?
    Maybe command center just uses windows xp regional/language settings or something?
    When I do a "select tstamp" from a table with timestamp (2002-04-03-14.35.56.086671) I get this format in command center: Apr 3, 2002 2:35:56 PM 086671.
    I'd like to see the actual timestamp-format in command center result panel and not the other fancy format.
    Any ideas anyone?

    /Leo

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You could use
    Code:
    CHAR(TSTAMP, ISO)
    to format a date-time field to your liking. By default I think you're right to say that CC uses the host OS date format.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    This is a note about CLP ... Guess it is the same for Command Centre ..

    The format of the date display of CLP depends on the locale settings of
    the
    client ...
    If you see an 'unexpected' format of date on your Windows systems,
    In 'Settings'
    In 'Regional Options'
    On the 'General Tab'
    Under 'Language settings for the system'
    Click on 'set default'
    Then select the 'English(United Kingdom)' (or whatever it is , in your case)

    This works on W2K ... If you are having a differnt OS, please see your
    Windows Administrator ... also,the 'Language Settings for the System' is
    different from 'Your Locale'


    If this helps, please let us know
    Thanks


    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Aug 2004
    Posts
    10
    Thanks, for you answer on this
    I got Windows XP SP1 here and it doesn't seem to be exactly the same options as you had on Win2K. I got 'control panel' -> 'regional and language options' -> 'Regional Options' and on that page 'standards and formats' and 'Location' which is both 'Swedish' as they should be for me.
    If I click on 'Customize' on 'standards and formats I get som definitions on how I'd like currency,time,date and numbers to be. I've changed the currency format from 123.456.789 to 123456789 and date and so on (even rebooted PC after changes), but none of this seems to affect DB2 command center GUI-result-panel. It seems to be locked on these weird formats that I don't want

    Any ideas ?

    /Lennart

Posting Permissions

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