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-A
TED]]
Sent: 29 August 2001 09:56
To: [EMAIL PROTECTED]
Subject: Date Comparison
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 l
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