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

Re: Timestamp weirdness

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: "emergency(dot)shower(at)gmail(dot)com" <emergency(dot)shower(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Timestamp weirdness
Date: 2005-07-26 01:12:22
Message-ID: 42E58DF6.6040406@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
emergency(dot)shower(at)gmail(dot)com wrote:

> If I TIMESTAMP WITH TIME ZONE is implemented on the server as a
> (timestamp, time zone)-pair

It's not, it's just a timestamp in UTC with no timezone stored.

> , the server should be able to cast
> TIMESTAMP WITH TIME ZONE correctly to TIMESTAMP WITHOUT TIME ZONE as
> described in the SQL standard:
> 
> From TIMESTAMP WITH TIME ZONE to TIMESTAMP WITHOUT TIME ZONE
>  TargetValue = SourceValue.UTC + SourceValue.TimeZone

I'd like to see this too, but Tom doesn't like it for
backwards-compatibility reasons.

-O

In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-07-26 03:02:34
Subject: TimeTest zone offset weirdness
Previous:From: Oliver JowettDate: 2005-07-26 00:02:08
Subject: work in progress: timestamp patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group