Re: Date conversion problems

In article <89k0lh$7vh$1_at_nnrp1.deja.com>,   baoba_at_my-deja.com wrote:
> I am working in pl/sql and am trying to find the total number of days
> between 2 specified dates. I am unable to get a number so I can do
 some
> math on the number.
> Peter

Hi,
subtraction of one date from another gives exact number of days between those two dates..

Ex: sysdate - (sysdate-10) gives 10
declare
x date;
y date;
n number;
begin
n :=x-y ;

end;
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 01 2000 - 00:00:00 CET