Re: Comparing Dates

Yes, just subtract them.

select round(date1 - date 2,0)
into v_days
from dual;

Mark

Tay Hwey Chen wrote in 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
Received on Thu May 27 1999 - 05:45:44 CDT