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.