Re: Comparing Dates

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Thu, 27 May 1999 11:12:23 +0100
Message-ID: <owsYOUAHqRT3Ewr3@ahardy.demon.co.uk>

In article <7ij3ed$4bl$1_at_gatekeeper.ornano.kapt.com>, Fred Ruffet <fruffet_at_kaptech.com> writes
>Justin,
>
>I know my answer seems to be strange, but it's the only one I know. I
>believe Oracle provides only one method to compare dates, which is the
>months_between function. It returns number of months between the two dates,
>and it can be floats (if difference can not be exactly expressed in months)
>
>select months_between(date1,date2) from table

Dates can be simply taken one from the other e.g. days_diff := date1 - date2;

>
>regards,
>
>Fred
>
>Tay Hwey Chen a écrit dans le message
><01bea816$052c78a0$d04a17cb_at_prabbit.labyrinth.net.au>...
>>Does anybody know how to compare dates to determind the number of days
>>between them in PL/SQL?
>>
>>
>>
>>Regards,
>>
>>
>>Justin
>
>

--
Andy Hardy. PGP key available on request

Received on Thu May 27 1999 - 05:12:23 CDT