Postgres Pro
Downloads
Home   >   mailing lists

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

From Karsten Hilbert
Subject Re: timezone() with timeofday() converts the wrong direction?
Date
Msg-id 20050424172141.U565@hermes.hilbert.loc
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?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
> As far as I know, it's not possible to get output like the following
> from the same query if the data type is timestamp with time zone:
>
> 2005-04-21 15:00:00-07
> 2005-04-21 22:00:00+00

Doesn't "at time zone" do what you need ?

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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: [Question]batch execute sql command
Next
From: Tony Caduto
Date:
Subject: Re: psqlODBC and Access