How to get decimal to date form

From: wireless <wireless200_at_yahoo.com>
Date: 17 Sep 2003 05:37:04 -0700
Message-ID: <90446ee7.0309170437.ed56658@posting.google.com>

In our database is a decimal field with format YMMDDhhmmss.9999999999 where the 9s are random digits. I'm trying to strip off just the YMMDD and put it in date form.

So far I came up with:
SUBSTR(TO_CHAR(rec_num,99999999999),1,6) AS Date which returns YMMDD.

For example where the rec_num is 30608124143.47069519725 the above functions return 30608.

I tried wrapping another TO_CHAR around it to try to format it to a date but this seems like it's a bit much for this purpose.

Any suggestions would be appreciated.

-David Received on Wed Sep 17 2003 - 07:37:04 CDT