Re: Date conversion problems

From: Mike Dwyer <dwyermj_at_co.larimer.co.us>
Date: 2000/03/02
Message-ID: <S_yv4.39$7o2.14751_at_wdc-read-01.qwest.net>#1/1


declare
days number;
begin
select date2 - date1 into days from dual; end;

<newopt_at_my-deja.com> wrote in message news:89m5cb$oc5$1_at_nnrp1.deja.com...
> 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
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Peter,
>
> I have the same problem, didi you get ananswer from anyone?
> If you did can you email me at JMitchelHall_at_mediaone.com (The JM&H have
> to be uppercase or the email server can't ind my mailslot.
>
> Or email to newopt_at_deja.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Mar 02 2000 - 00:00:00 CET

Original text of this message