Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #132

Re: Timestamp with Timezone (Oracle versus Postgres)

Show all headers | View raw

Jasen Betts wrote:> On 2011-06-10, vinu <vinu.rm@gmail.com> wrote:
>> Is timestamp with timezone a ANSI SQL (or some other) standard data
>> type ?

> yes, there are rules about how it behaves and as I understand it
> postgres mets all the requirements.

Maybe PostgreSQL meets all the requirements, but as I researched here
http://archives.postgresql.org/pgsql-general/2009-06/msg01372.php
the Standard seems to suggest that the time zone information should be
stored along with the date.
Tom Lane did not seem to disagree:
http://archives.postgresql.org/pgsql-general/2009-06/msg01389.php

I didn't find anything in the Standard that is explicit on how time zone
information should be handled, but it seems that what the writers had in
mind was closer to Oracle's implementation than to PostgreSQL's.

[...]

>> In this an issue with postgresql or a conscious implementation
>> decision?

> as far as I can tell is was a conscious decision.

Even if, Tom Lane's remark quoted above indicates that there have been
debates (I'm too lazy to research), and the status quo is retained at least
partly because other options would be inconvenient to implement.

Yours,
Laurenz Albe 

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

Timestamp with Timezone (Oracle versus Postgres) vinu <vinu.rm@gmail.com> - 2011-06-10 03:30 -0700
  Re: Timestamp with Timezone (Oracle versus Postgres) Mladen Gogala <gogala.mladen@gmail.com> - 2011-06-10 13:39 +0000
  Re: Timestamp with Timezone (Oracle versus Postgres) Jasen Betts <jasen@xnet.co.nz> - 2011-06-12 10:32 +0000
    Re: Timestamp with Timezone (Oracle versus Postgres) "Laurenz Albe" <invite@spam.to.invalid> - 2011-06-14 11:43 +0200

csiph-web