Re: timestamp with/without time zone

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: timestamp with/without time zone
Date: 2001-06-20 21:42:49
Message-ID: Pine.LNX.4.30.0106202331020.725-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Lockhart writes:

> SQL9x "timestamp" has no notion of time zones. PostgreSQL "timestamp"
> does.

AFAICT, it does not. The value is stored in UTC (more or less) and is
converted to the local time zone for display. But a data type is defined
in terms of storage, not display. In fact, if you use a language binding
that converts PostgreSQL values directly to native data types, then the
time zone never appears.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mikheev, Vadim 2001-06-21 00:10:45 RE: RE: [BUGS] Update is not atomic
Previous Message Jan Wieck 2001-06-20 21:27:20 Re: [HACKERS] RE: Update is not atomic