Re: date format question

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Thu, 17 May 2001 06:40:41 GMT
Message-ID: <JnKM6.17706$p33.325176@news1.sttls1.wa.home.com>

Just subtract the number of days and do the multiplication. If you subtract 2 dates then you get the days. Or convert both to Julian (I believe to_char( your_date,'J')) and subtract them and do the multiplication of the number of seconds in a day.
Jim

"Zhiliang Hu" <zhu_at_genomicfx.com> wrote in message news:3B02FC37.1AB2E197_at_genomicfx.com...
>
> How to format an Oracle date to be shown as the number of seconds since
> 1970?
>
> Thanks!
>
> Zhiliang
>
Received on Thu May 17 2001 - 01:40:41 CDT