[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Date math

Hi, I am using SQR3 with an Oracle 7.2 database  and want to use a variable
for date math. The syntax is testdate < sysdate - #offset. The problem I'm
having is that if I put in a number instead of the #offset it works fine
(say 30, I get 30 days less), the procedures to get the #offset are working
fine (I get the numerical result I expected) but SQR treats #offset as a 0.
Is this a bug? what am I missing?

            charlied@tir.com