Re: When it is better to use "timestamp without time zone"?

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: emilu(at)cs(dot)concordia(dot)ca
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: When it is better to use "timestamp without time zone"?
Date: 2006-01-03 22:25:58
Message-ID: D2CE084B-8521-4A2C-8E51-E66C2593F048@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Jan 3, 2006, at 16:01 , Emi Lu wrote:

> I need to know when it is better that we use "timestamp without
> time zone" ? And when it is better to use "timestamp with time zone"?

In my opinion, if you want to store a timestamp, you should always
use timestamp with time zone, as the UTC offset information is
necessary to provide a unique timestamp value.

Michael Glaesemann
grzm myrealbox com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-01-03 22:50:04 Re: [GENERAL] PL/pgSQL Function Help
Previous Message Emi Lu 2006-01-03 22:01:07 When it is better to use "timestamp without time zone"?