Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    54

    Unanswered: how do we do date and time formats?

    Hi,

    Here is my query and result

    db2 => SELECT PUTDATE, COUNT(*) FROM DB2ADMIN.MQMDLOG WHERE PUTDATE BETWEEN '2004-03-29' AND '2004-03-30' GROUP BY PUTDATE

    PUTDATE 2
    ---------- -----------
    2004-03-29 9769
    2004-03-30 5210

    2 record(s) selected.

    I want result like this

    PUTDATE 2
    ---------- -----------
    29/03/2004 9,769
    30/03/2004 5,210

    How do we get the above result??

    I appreciate ur help?

    Thanks

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

    Re: how do we do date and time formats?

    Originally posted by manth


    I want result like this

    PUTDATE 2
    ---------- -----------
    29/03/2004 9,769
    30/03/2004 5,210

    How do we get the above result??
    Look up the CHAR() function in SQL Reference

  3. #3
    Join Date
    Mar 2004
    Posts
    54
    I did not find good material in the web.

    Could you suggest me a good link

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Originally posted by manth
    I did not find good material in the web.

    Could you suggest me a good link
    http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

  5. #5
    Join Date
    Mar 2004
    Posts
    54

    Thumbs up

    thanks for ur help

Posting Permissions

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