Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 26 Jul 2005 13:12:22 +1200
- Message-id: <42E58DF6.6040406@opencloud.com> <text/plain>
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
- References:
- Timestamp weirdness
- From: emergency(dot)shower(at)gmail(dot)com
- Re: Timestamp weirdness
- From: Oliver Jowett
- Re: Timestamp weirdness
- From: Tom Lane
- Re: Timestamp weirdness
- From: emergency(dot)shower(at)gmail(dot)com
- Timestamp weirdness
- Prev by Date: work in progress: timestamp patch
- Next by Date: TimeTest zone offset weirdness
- Previous by thread: Re: Timestamp weirdness
- Next by thread: Re: Timestamp weirdness
- Indexes: