Re: now() AT TIME ZONE 'GMT'; - Mailing list pgsql-general

From Richard Emberson
Subject Re: now() AT TIME ZONE 'GMT';
Date
Msg-id 3CB30540.2151BD78@phc.net
Whole thread Raw
In response to now() AT TIME ZONE 'GMT';  (Richard Emberson <emberson@phc.net>)
List pgsql-general
Tom Lane wrote:

> Richard Emberson <emberson@phc.net> writes:
> > If I want a column to have a default TIMESTAMP of 'now' but not in PST
> > timezone but GMT,
>
> It strikes me that you have a conceptual error.  Type TIMESTAMP (ie,

I guess so. So it is during the retrieval of a timestamp using jdbc, where
the timestamp
is converted into a java.sql.Timestamp that it gets converted to a local
timezone.
So I will have to use the jdbc access method that preserves (actually where
one can
set the desired timezone) the timezone.

Richard


pgsql-general by date:

Previous
From: "Papp, Gyozo"
Date:
Subject: Re: SPI_execp() failed in RI_FKey_cascade_del()
Next
From: Patrick Welche
Date:
Subject: Re: numeric test on RiscPC