Timezones -- what comes out does not go in?

From: "Julian Scarfe" <julian(at)avbrief(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Timezones -- what comes out does not go in?
Date: 2006-08-16 09:18:03
Message-ID: 06f601c6c114$e1ab89a0$0600a8c0@Wilbur
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The timezone on our boxes is set to Etc/UCT (possibly a distro default).

(psql 8.1.4)

=> select to_char(current_timestamp, 'HH24:MI:SS TZ');
to_char
--------------
09:05:48 UCT
(1 row)

=> select '09:05:48 UCT'::time;
ERROR: invalid input syntax for type time: "09:05:48 UCT"

UTC works, of course:

=> select '09:05:48 UTC'::time;
time
----------
09:05:48
(1 row)

Is this behaviour expected? Desirable?

Thanks
Julian

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2006-08-16 09:37:17 Re: How to add days to date
Previous Message Nico 2006-08-16 07:58:53 Restarting Slony crashes Postgresql?