On Mon, Mar 13, 2006 at 08:37:16 -0500,
John Christopher <jcxxr(at)yahoo(dot)com> wrote:
> 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.
In response to
pgsql-novice by date
|Next:||From: Michael Guerin||Date: 2006-03-14 14:44:49|
|Subject: log rotation|
|Previous:||From: Michael Swierczek||Date: 2006-03-13 20:40:41|
|Subject: Re: Exception in thread "main" java.lang.OutOfMemoryError|