Re: PL/SQL Question

From: <bialik_at_wis.weizmann.ac.il>
Date: Thu, 16 Apr 1998 14:08:23 -0600
Message-ID: <6h5kv7$ot$1@nnrp1.dejanews.com>

Hi.
Try :
select sysdate - ( 1/24 ) from dual;

Michael.

In article <353527AC.BA7083F9_at_spb.runnet.ru>, Igor Sereda <sereda_at_spb.runnet.ru> wrote:
>
> Hi,
>
> if you subtract one date from another, you'll receive number of days
> between two dates. Multiply it by 86400 to get number of seconds.
> There's no way i know to get more accurate number.
>
> Regards,
> Igor
>
> dicaprio wrote:
> >
> > Hi,
> >
> > I have got this problem : I must subtract a date_variable from another ;
> > e.g. I want to subtract one hour 1:00 from SYSDATE
> >
> > Select (SYSDATE-TO_DATE('1:00','hh24:mi') from dual ;
> >
> > and the OUT is a wrong result.
> > Thanks in advance
> >
> > Veramente Grato
> > Clemente di Caprio
> >
> > dicaprio_at_tin.it
>
> --
> Igor Sereda,
> ITC, Russia
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 16 1998 - 15:08:23 CDT