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
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.
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 = -
