Re: Timestamp with time zone: why not?

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: km(at)acrasis(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Timestamp with time zone: why not?
Date: 2007-05-24 18:18:08
Message-ID: 4655D6E0.80405@g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

km(at)acrasis(dot)net wrote:
> Would I be right in thinking that, in general, a column to hold
> timestamp values is best created with type 'TIMESTAMP WITH TIME ZONE'
> and not 'TIMESTAMP' nor 'TIMESTAMP WITHOUT TIME ZONE'?
>
> To put it another way, for what reasons might the 'TIMESTAMP' type be
> preferred to 'TIMESTAMP WITH TIME ZONE'?
>
We use the database to store one minute roll up stats from our main
application. Each of these has a timestamp on it.

There's really no need for timestamptz in this instance.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2007-05-24 18:18:52 Re: postgres - oid question
Previous Message Dave Page 2007-05-24 18:05:59 Re: Integrity on large sites