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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Dates

Re: Dates

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 2000/04/14
Message-ID: <8d6k6q$a89$1@news.liv.ac.uk>#1/1

Sonia Gillespie (sonia_gillespie_at_lagan.com) wrote:
: There is a months_between method to calculate the months between a certain
: date. Is there a way of calculating the days between two dates?
 

: --
: Sonia Gillespie
: E-mail: sonia_gillespie_at_lagan.com

Subtract one date from the other. If your dates stored with times day fractions will be shown. Just want whole days use trunc.

HTH Helen Received on Fri Apr 14 2000 - 00:00:00 CDT

Original text of this message

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