Re: Calc. diff. of dates in min.

bhavinsh_at_my-deja.com wrote:
>
> Hi,
>
> How do you get a difference in two oracle dates
> (format = 'DD-MM-YYYY HH24:MI:SS') in minutes?
> Are there any oracle functions that will do
> this?
>
> Oracle 8.1.6
> Red Hat 6.0
>
> Thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

select (date2-date1)*24*60 from mytable;

MF

-- 
matt_foster_uk_at_yahoo.co.uk