Re: Huh? Data typing bug?

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 josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco