Skip site navigation (1) Skip section navigation (2)

Re: Automatic date/time

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: John Christopher <jcxxr(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Automatic date/time
Date: 2006-03-13 21:01:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Mon, Mar 13, 2006 at 08:37:16 -0500,
  John Christopher <jcxxr(at)yahoo(dot)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.

In response to

pgsql-novice by date

Next:From: Michael GuerinDate: 2006-03-14 14:44:49
Subject: log rotation
Previous:From: Michael SwierczekDate: 2006-03-13 20:40:41
Subject: Re: Exception in thread "main" java.lang.OutOfMemoryError

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group