Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there a dateadd() function?

Re: Is there a dateadd() function?

From: Arjan van Bentem <avbentem_at_DONT-YOU-DARE-cable.a2000.nl>
Date: Wed, 22 Jul 1998 07:00:04 +0200
Message-ID: <6p3rkb$1h6$1@newton.a2000.nl>


>The results you have descibe appear to be just whole days (?)

No. (Date2- Date1) * 24 gives you a number with a lot a decimals, like 1.8372342. The whole part is the number of days, and that is why I used trunc(..) in my second example.

Just try, you'll see.

Arjan. Received on Wed Jul 22 1998 - 00:00:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US