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

From Tom Lane
Subject Re: timezone() with timeofday() converts the wrong direction?
Date
Msg-id 19419.1114443383@sss.pgh.pa.us
Whole thread Raw
In response to Re: timezone() with timeofday() converts the wrong direction?  (Michael Fuhr <mike@fuhr.org>)
Responses Re: timezone() with timeofday() converts the wrong direction?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Michael Fuhr <mike@fuhr.org> writes:
> The problem I was discussing involves getting *different* time zone
> specifictions in the output.  That is, something like this (which
> apparently is possible in 7.1.3 but not in later versions):

>                f               |           timezone
> -------------------------------+-------------------------------
>  2005-04-24 22:25:51.669218+00 | 2005-04-24 23:25:51.669218+01

It was not really possible in 7.1 either (nor any previous version).
The secret to the above is that in 7.1 the timezone() function's
result is *text*, not a timestamp object.  So it's purely a display
artifact ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Jeff Eckermann"
Date:
Subject: Re: artificial keys or not?
Next
From: Thomas F.O'Connell
Date:
Subject: Re: DDL from psql console?