| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2005-07-26 03:02:34 | TimeTest zone offset weirdness |
| Previous Message | Oliver Jowett | 2005-07-26 00:02:08 | work in progress: timestamp patch |