Edd,
One possibility is during the select statement:
select
sysdate
,trunc(sysdate) - 2
,to_date( '28-AUG-2001' ) - (trunc(sysdate) - 2)
,to_date( '27-AUG-2001' ) - (trunc(sysdate) - 2)
,to_date( '26-AUG-2001' ) - (trunc(sysdate) - 2)
from dual
Tom
On Wed, Aug 29, 2001 at 09:56:21AM +0100, Edd Dawson wrote:
> Hi,
>
> I have dates that I get off an Oracle database and so come in the
> format DD-MMM-YY (e.g 10-AUG-01) I would like to be able to do a
> comparison that decides whether the date I get off the Oracle
> database is more or less than 2 days ago.
>
> I seem to be stumped on this one. Could anyone point me in the
> right direction?
>
> Thanks very much.
>
> Edd
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
