Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: Having trouble with date field on AS400 DB2


    I have a number of "date" fields that are simply integers. The problem is they never pad the dates with 0. So 10512 is October 5th 2012. The problem is it makes it impossible to substring to get things in day, month, year. I tried just casting it to a date and that gave me bad data. Does anyone know of a way to work with crazy dates like this.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    Without any consistent method of storing the data, then you task is impossible.

    11512 --> is this Jan 15, 2012 or Nov 5, 2012?


Posting Permissions

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