Re: date differences
From: Dwayne King <dwayne_at_kridan-consulting.com>
Date: Mon, 20 Nov 2000 01:06:48 GMT
Message-ID: <IO_R5.138037$78.42581600_at_news3.rdc1.on.home.com>
Date: Mon, 20 Nov 2000 01:06:48 GMT
Message-ID: <IO_R5.138037$78.42581600_at_news3.rdc1.on.home.com>
Just treat them like any other number:
declare
d1 date := sysdate;
d2 date := sysdate+5000;
diff number;
begin
diff := d2-d1;
end;
"LEPP" <ytgh_at_hotmail.com> wrote in message
news:JpEP5.125340$j6.13217940_at_news1.rdc1.va.home.com...
> What is the best way to take the difference of two dates from within a
> PL/SQL statement.
>
> Thanks
>
> Lepp
Received on Mon Nov 20 2000 - 02:06:48 CET