Re: convert DATE to NUMBER
From: Gorm Larsen <gorm_larsen_at_vestjyde.dk>
Date: Sun, 27 Feb 2000 19:28:01 +0100
Message-ID: <MPG.13238b1a749422739896a9_at_valhal>
Date: Sun, 27 Feb 2000 19:28:01 +0100
Message-ID: <MPG.13238b1a749422739896a9_at_valhal>
In article <38B9571A.92406828_at_bol.boliden.se>,
hakan.wahlberg_at_bol.boliden.se says...
> 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.
SQL> select (trunc(sysdate) - trunc(sysdate+5)) from dual;
(TRUNC(SYSDATE)-TRUNC(SYSDATE+5))
-5
-- Gorm LarsenReceived on Sun Feb 27 2000 - 19:28:01 CET