Originally posted by marknel

I know this is a mess, but I'm trying to gain an understanding so I can A: Make it work, B: work as effiecently as possible and C: learn something.
You're right, this is a mess...

You know you can:
Code:
SELECT a.c1, '|',
       TO_CHAR(TO_DATE('01-JAN-1970','DD-MON-YYYY') + c6/86400,'MM-DD-YYYY') mod_date, 
.
.
.
FROM T215 a
WHERE ...