Re: convert DATE to NUMBER
From: Nick Laborera <nlaborera_at_home.com>
Date: Sun, 27 Feb 2000 17:53:11 GMT
Message-ID: <bwdu4.23352$pN1.316284_at_news1.rdc1.nj.home.com>
Date: Sun, 27 Feb 2000 17:53:11 GMT
Message-ID: <bwdu4.23352$pN1.316284_at_news1.rdc1.nj.home.com>
use TO_CHAR(DATE1, 'SSSSS') - TO_CHAR(DATE2,'SSSSS')
cheers,
Nicky
"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 Sun Feb 27 2000 - 18:53:11 CET