Tom,
> IIRC, number of days (as an int) is what that's supposed to produce.
>
> If that's not what you wanted, maybe you ought to cast the dates to
> timestamp or some such.
I see. It was never made clear to me that here the DATE type differs
from DATETIME and TIMESTAMP significantly.
This makes some sort of sense, now.
Correct me if I'm wrong:
DATE + INT4 = DATE
DATE - DATE = INT4
But:
DATETIME + INTERVAL = DATETIME
DATETIME - DATETIME = INTERVAL
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology [EMAIL PROTECTED]
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
