Re: calculation with's date

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Thu, 20 Sep 2001 15:28:06 GMT
Message-ID: <aWnq7.600$z61.334614@news1.news.adelphia.net>

Oracle's date type is
<date_in_days_since_?>.<time_in_seconds_since_midnite>, so after the subtraction you will still have days.seconds

You can figure out how many seconds the days represent by doing trunc(date_field) * 3600 * 24, I off the top of my head I don't know how to add in the original seconds.

It will probably come to me right after I click on the next newsgroup though.

"Thomas" <thomas.hiller_at_warema.de> wrote in message news:6e366956.0109200629.53a8163a_at_posting.google.com...
> Hello,
>
> is it possible to substract two date-format columns and get the
> correct amount of seconds
>
> regards
> Thomas
Received on Thu Sep 20 2001 - 10:28:06 CDT