steve silvers wrote:
I have a table called PERS and it has an END_DATE column. This is a
date field. If the end date is set to 5 or 6 or 10 days from now I
need to know when it's 1 day (24 hours) before the END_DATE. I'm
trying something like:
SELECT EndDate, CASE WHEN EndDate = - 86400
Todd Beverly wrote:
Check out the interval expression...
This works in Oracle 8i:
select column from table where check_date (sysdate - interval '1' day);
Todd,
Is 'interval' an actual Oracle statement or keyword? I couldn't find it
in my Oracle 8: The Complete Reference book.
Rick
Richard A. Nakroshis wrote:
Todd Beverly wrote:
Check out the interval expression...
This works in Oracle 8i:
select column from table where check_date (sysdate - interval '1' day);
Todd,
Is 'interval' an actual Oracle statement or keyword? I couldn't find it
in my Oracle 8: The