On Mon, 28 Jun 2004, Tom Lane wrote:
> Richard Huxton <[EMAIL PROTECTED]> writes:
> > W.B.Hill wrote:
> >> SELECT d+'45 days ago'::interval FROM test;
Yep - it's the clock's going forward that does it. Doh! The quick'n'dirty
work around '45.3 days ago' was what I used but just a straight -45 is
b
Richard Huxton <[EMAIL PROTECTED]> writes:
> W.B.Hill wrote:
>> SELECT d+'45 days ago'::interval FROM test;
>>
>> Why the different times??? Why the times???
> At a guess, the date is being converted into a timestamp with timezone
> so you can add the interval to it.
Yeah, I think that will be
