Results 1 to 5 of 5

Thread: iseries issue

  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: iseries issue

    Hi Experts,

    We have an issue with db2 in iseries as we are not able to get date before 1940.We are getting the value as NULL but stil the data is there in database.

    Please Help
    TIA

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    iSeries DB2 Universal Database for iSeries SQL Reference Version 5:
    Date
    A date is a three-part value (year, month, and day) designating a point in time
    under the Gregorian calendar16, which is assumed to have been in effect from the
    year 1 A.D. The range of the year part is 0001 to 9999. The date formats *JUL,
    *MDY, *DMY, and *YMD can only represent dates in the range 1940 through 2039.

    .....
    So, you may want to use the date format *ISO, *USA, *EUR or *JIS.

  3. #3
    Join Date
    Jan 2009
    Posts
    153
    How to use the date format date format *ISO, *USA, *EUR or *JIS.

  4. #4
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    How to use the date format date format *ISO, *USA, *EUR or *JIS.
    I don't know exactly.
    Please see manuals including "DB2 Universal Database for iSeries SQL Reference Version 5".
    The SET OPTION statement may help you.

  5. #5
    Join Date
    Jan 2009
    Posts
    153
    Thanks Tonkuma,

    Can you please tell me where and how to execute the set option i tried
    SET OPTION DATFMT=ISO and getting error

Posting Permissions

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