Wichert Akkerman wrote:
> Which outputs:
>
> 2010-01-15 12:30:00+01:00
> 2010-08-15 12:30:00+01:00
>
>
> The second timestamp should have +02:00 as timezone due do daylight
> saving differences. Unfortuantely the timezone information reported on
> the column has a fixed offset instead of the more i
Postgres can handle timezones fairly well. Using a direct select you can
see how it handles daylight saving correctly:
test=# select
'2010-01-15 12:30 Europe/Amsterdam'::timestamp with time zone,
'2010-01-15 12:30 Europe/Amsterdam'::timestamp with time zone +
interval '7 months'