Gerhard Wiesinger writes:
> Ok, the "problem" is:
> --
>datetime >= '2009-03-09 00:00:00.0'
>AND datetime < '2009-03-10 00:00:00.0'
> -- Index Cond: ((datetime >= '2009-03-09 00:00:00+01'::timestamp with time
> zone) AND (datetime < '20
On Sun, 21 Jun 2009, Richard Huxton wrote:
Gerhard Wiesinger wrote:
Hello,
It is unclear to me how implicit conversion/comparision of timestamp with
and without timezone works.
It's not entirely clear where the problem is. You don't say the results
you're getting or what you thought they
Gerhard Wiesinger wrote:
Hello,
It is unclear to me how implicit conversion/comparision of timestamp
with and without timezone works.
It's not entirely clear where the problem is. You don't say the results
you're getting or what you thought they should be.
Hello,
It is unclear to me how implicit conversion/comparision of timestamp with
and without timezone works.
--
-- datetime TIMESTAMP WITH TIME ZONE
-- datetime entries are with UTC+01 and UTC+02 done
-- 2009-03-09: UTC+01
-- 2009-06-12: UTC+02
-
