Re: timezone() with timeofday() converts the wrong direction? - Mailing list pgsql-general

> > >   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