Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    us.ca
    Posts
    9

    Unanswered: formatting a date?

    i'm selecting a date from db2 from an as/400, and the system is setup to output MM/dd/yy

    the problem is that when it comes across a date which conflicts with a 2 digit century, it outputs '++++++++'

    is it possible to format the date in the query string? i'm using jdbc to interface with the system.

    any insight would be greatly appreciated. thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I'm not familiar with db2/400 but for UDB I would use CHAR() function. You may want to look at the SQL reference for your platform.

Posting Permissions

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