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

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: postgres-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: timezone() with timeofday() converts the wrong direction?
Date: 2005-04-24 15:21:41
Message-ID: 20050424172141.U565@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2005-04-24 15:43:21 Re: psqlODBC and Access
Previous Message Michael Fuhr 2005-04-24 14:07:23 Re: [Question]batch execute sql command