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

nesans wrote:

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

Is this homework?
If not, you should have considered the way to convert packed date to
db2 date bofore you put data in a table with packed data format.
DATE('1900-01-01') + (packed_date/100-1) months +
(MOD(packed_date,100)-1) days