Timestamp with time zone: why not?

From: km(at)acrasis(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: Timestamp with time zone: why not?
Date: 2007-05-23 23:54:26
Message-ID: 20070523235426.GC713@acrasis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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'?
--
KM

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Pavlov 2007-05-23 23:56:56 Re: Geographic data sources, queries and questions
Previous Message Harpreet Dhaliwal 2007-05-23 23:48:18 Re: Vacuum DB in Postgres Vs similar concept in other RDBMS