On Mon, Mar 13, 2006 at 08:37:16 -0500,
John Christopher <jcxxr@yahoo.com> wrote:
> Hello,
> To follow up on that, how to make sure the timestamp is always stored and
> displayed at, for instance, time zone 'zulu'
> Something like
> create table ...
> {
> datetime timestamptz default 'now() at time zone \'zulu\''
> }
> does not work; PostgreSQL complains about the syntax. Any idea.
You need to do that in the queries that are referencing the timestamps.