Re: Date/Time Calculations

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 17 Nov 1999 05:22:04 +0100
Message-ID: <942812587.18106.0.pluto.d4ee154e@news.demon.nl>

Yes, and what is returned is a real number, so just multiply it by 24, or by 24*60, or by 24*3600, etc
and you will get the appropriate unit.

Hth,

--
Sybrand Bakker, Oracle DBA
Duncan Chilvers <duncanc_at_ukf.net> wrote in message news:3831ee70.0_at_news2.cluster1.telinco.net...
> Does anyone know of a way to calculate the difference in seconds or
minutes
> between 2 date columns?
>
> I have looked through all the functions, but the smallest time granularity
> that seems possible is a day. Can I get at anything smaller?
>
>
>
>
Received on Tue Nov 16 1999 - 22:22:04 CST