Re: Date Comparison

2001-08-29 Thread Thomas A . Lowery
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

RE: Date Comparison

2001-08-29 Thread John Edwards
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

Date Comparison

2001-08-29 Thread Edd Dawson
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