Re: convert DATE to NUMBER
From: Tom Zamani <tomz_at_redflex.com.au>
Date: Mon, 28 Feb 2000 10:14:06 +1100
Message-ID: <89cbk5$de0$1_at_perki.connect.com.au>
Date: Mon, 28 Feb 2000 10:14:06 +1100
Message-ID: <89cbk5$de0$1_at_perki.connect.com.au>
Oracle does this for you, you do not need to convert the date in to any
thing.
Oracle internaly will convert the date into number of days and then uses
that number in the calulations.
eg
SQL> select (sysdate-(sysdate-10)) from dual;
(SYSDATE-(SYSDATE-10))
10
The result will be in days.
Tom
Håkan Wahlberg <hakan.wahlberg_at_bol.boliden.se> wrote in message
news:38B9571A.92406828_at_bol.boliden.se...
> How do I convert DATE to NUMBER? I need to calculate the difference
> between
> two dates (date1 - date2) and use the the difference as a number.
>
> Thanks for any help
> /Håkan Wahlberg
>
Received on Mon Feb 28 2000 - 00:14:06 CET