I have date stored in table as following example:
115514 Equates to March 14, 1996
it is stored from the date of 1900-01-01 to 1996-03-14
Month/Year = 1155 and day = 14
96 X 12 = 1152 + 3 = 1155
I want to be able to convert this to actual date using DB2
Please help
Thanks
N. Sinnadurai