Re: Comparing Dates

From: Delbert Hickman <hickman_delbert_at_prc.com>
Date: Thu, 27 May 1999 08:18:09 -0400
Message-ID: <374D3801.84BD89C@prc.com>

Hi Tay,

SQL version:

SQL>select round(to_date('27-may-99') - to_date('26-may-99')) from dual;

SQL>1 PL/SQL version:

var1 := round(to_date('27-may-99') - to_date('26-may-99'));

Given the date is in character format else no need to do to_date conversion.

Thanks, Delbert

Tay Hwey Chen wrote:

> 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 - 07:18:09 CDT