Re: Date arithmetic

Hi!

On Mon, 25 Jan 1999 12:11:14 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:

>you can get either TOTAL (days, hours, minutes, seconds) between 2 dates simply
>by subtracting them or with a little mod'ing you can get
>Days/Hours/Minutes/Seconds between.
[..]

Thanks a lot.
I made a try simply subtracting each date from the other and found out that the result was in decimal days.
That was the solution, because I now have to query for > 7 to get obosolete entries. (obsolete = older than one week).

---
Lars Reineke
http://www.planet-interkom.de/pinhead
mailto:reineke_at_kreiskrankenhaus-hameln.de
---