Number/date - operator

From: Paul MacMillan <max_at_varis.demon.co.uk>
Date: Tue, 30 Jun 1998 20:19:53 +0100
Message-ID: <35993A59.54160F1C_at_varis.demon.co.uk>

Engaged in a Y2K audit of Developer/2000 for a client, I was looking through the STANDARD PL/SQL package when I came across the following operator:

• (left IN NUMBER, right IN DATE) RETURN DATE

I didn't think that this syntax made sense "number - date = date?" (it doesn't work in SQL*Plus). When I tried it out in Forms I got the same results as you would do with the more familiar "date - number = date" form, e.g.

        30-JUN-98 - 1 = 29-JUN-98         1 - 30-JUN-98 = 29-JUN-98 Anyone know why this exists in this form? Still doesn't make sense to me...

-- 

Paul MacMillan
[Max]

max_at_varis.demon.co.uk

Received on Tue Jun 30 1998 - 21:19:53 CEST