Re: How many months are in a range of dates?

From: Slavko Stemberger <starsoft_at_orbonline.net>
Date: 1995/07/27
Message-ID: <3v73st$un2_at_george.orbonline.net>#1/1


Claudio Longo <Claudio_at_bnr.ca> wrote:

>Using a column (hire_date) and sysdate, how can I select the
>number of months a person has worked.

Try

   select months_between(sysdate, hire_date)      from emp
 where ...

This will calculate the months a person has worked. You may wish to round or truncate this value depending on your needs. Received on Thu Jul 27 1995 - 00:00:00 CEST

Original text of this message