Subtraction of a number from a date in Oracle/Oracle Lite?

From: Jørgen Jamt <JorgenJ_at_bgnett.no>
Date: Fri, 5 Jun 1998 12:21:41 +0200
Message-ID: <6l8iqj$ohl$1@o.online.no>

Hello!
I'm trying to run a query that subtracts a number of days from a date. It seems like Oracle 7.3.4 and Oracle Lite 3.0.5.1.6 are handling this differently.

In Oracle 7.3.4 this statement works fine:

"SELECT (STARTDATE - PRIORWARNING) "WDATE" FROM
A_TABLE
WHERE
A_CONDITION" The datatypes are as follows:
STARTDATE (DATE)
PRIORWARNING(NUMBER10,0) In Oracle Lite I get this error when I try to execute the same query:

"ERROR at line 1:

OCA-30021: error preparing/executing SQL statement [POL-5215] wrong datatype in operand"

Can anyone please help me with this?

Thank you for your time!

Jørgen Jamt Received on Fri Jun 05 1998 - 05:21:41 CDT