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
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