Re: timezone() with timeofday() converts the wrong direction?

> > > select f, f::timestamp at time zone 'MEZ' from test;
> > > f | timezone
> > > -------------------------------+----------------------------
> > > 2005-04-24 22:25:51.669218+00 | 2005-04-24 23:25:51.669218
> > > (1 row)
> >
> > Huh ? This IS different time zones from the same timestamp
> > within the same query, isn't it ??
>
> No, it isn't. In the above example from 7.2.7 the second column
> has no time zone specification whatsoever;
You are correct.

However, how about this:

version
---------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)

=> select now() as "MESZ", now() at time zone 'MEZ' as "MEZ", now() at time zone 'UTC' as "UTC" ;

MESZ | MEZ | UTC
------------------------+------------------------+------------------------
2005-04-25 17:13:19+02 | 2005-04-25 16:13:19+01 | 2005-04-25 15:13:19+00
(1 row)

Is that eventually it ?

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346