Results 1 to 5 of 5

Thread: Displaying Time

  1. #1
    Join Date
    Jul 2004
    Location
    Ottawa, Canada
    Posts
    58

    Unanswered: Displaying Time

    Is there a function to display a timestamp in the format:

    '2004/08/11 10:22:24 AM'

    All i have found so far is:
    varchar_format(current timestamp,'YYYY-MM-DD HH24:MIS')

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I believe that that is all that comes with DB2. You will need to write your own UDF to get what you want.

    Andy

  3. #3
    Join Date
    Jul 2004
    Posts
    53
    Ain't that good enough?


    Quote Originally Posted by ApoPen
    Is there a function to display a timestamp in the format:

    '2004/08/11 10:22:24 AM'

    All i have found so far is:
    varchar_format(current timestamp,'YYYY-MM-DD HH24:MIS')

  4. #4
    Join Date
    Jul 2004
    Location
    Ottawa, Canada
    Posts
    58
    unfortunatly not, we are doing a conversion from mySQL to DB2, but the presentation to the clients have to remain the same.

  5. #5
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165
    See:
    http://www.cs.ucla.edu/classes/winte...1/DB2Time.html

    You might want to use them to write the UDF.

    Newbie

Posting Permissions

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