Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 24 May 2007 13:18:08 -0500
- Message-id: <4655D6E0(dot)80405(at)g2switchworks(dot)com>
km(at)acrasis(dot)net wrote:
We use the database to store one minute roll up stats from our main application. Each of these has a timestamp on it.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'?
There's really no need for timestamptz in this instance.
- References:
- Timestamp with time zone: why not?
- From: km
- Timestamp with time zone: why not?
- Prev by Date: Re: Integrity on large sites
- Next by Date: Re: postgres - oid question
- Previous by thread: Re: Timestamp with time zone: why not?
- Next by thread: why postgresql over other RDBMS
- Indexes: