| From: | Xavier Robin <xavier(dot)robin(at)bluewin(dot)ch> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Timestamp with time zone |
| Date: | 2010-06-30 12:59:37 |
| Message-ID: | 4C2B3FB9.20800@bluewin.ch |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello,
I'm running a Debian Lenny box with PostgreSQL 8.4.4 from the backports.
I have a question regarding timestamps with time zone. I can't get time
zones inserted into my timestamp with time zone columns. For example:
> CREATE TABLE testcase(
> created TIMESTAMP WITH TIME ZONE
> );
> INSERT INTO testcase VALUES (TIMESTAMP WITH TIME ZONE '2005-01-01 00:00+01');
> SELECT created, EXTRACT(TIMEZONE FROM created) FROM testcase;
> created | date_part
> ------------------------+-----------
> 2004-12-31 23:00:00+00 | 0
> (1 ligne)
Or from the docs:
> SELECT TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54+02';
> timestamptz
> ------------------------
> 2004-10-19 08:23:54+00
In both examples, the timezone is lost. I read that
> To ensure that a literal is treated as timestamp with time zone, give it the correct explicit type
but how can I do that in pactice?
Thanks,
Xavier
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Xavier Robin | 2010-06-30 13:12:39 | Timestamp with time zone |
| Previous Message | Thom Brown | 2010-06-30 12:41:45 | Re: null vs empty string |