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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Wed, 23 May 2007 16:54:26 -0700
  • Message-id: <20070523235426(dot)GC713(at)acrasis(dot)net>
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
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group