From: | "Wright, George" <George(dot)Wright(at)infimatic(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Singapore time zone |
Date: | 2008-05-21 15:18:16 |
Message-ID: | 51548D6D5BEB57468163194A8C1A0E98C6BB55@MAGPTCPEXC02.na.mag-ias.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
We seem to be having a time zone problem on a box configured for
Singapore timezone. The OS is Suse10.2 PostgreSQL version is 8.1.5.
This simple PHP file prints 2008-05-21 23:04:24SGT
<?php
$d = date('Y-m-d H:i:sT', time());
print $d;
?>
Testing that timestamp string in PostgreSQL fails. It works ok with the
other time zone.
host=> SELECT CAST('2008-05-21 23:04:24SST' AS TIMESTAMP WITH TIME
ZONE);
timestamptz
------------------------
2008-05-22 05:04:24+08
(1 row)
host=> SELECT CAST('2008-05-21 23:04:24SGT' AS TIMESTAMP WITH TIME
ZONE);
ERROR: invalid input syntax for type timestamp with time zone:
"2008-05-21 23:04:24 SGT"
Is this something that's been fixed in a later version or is it some
other issue?
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-05-21 22:22:51 | Re: Singapore time zone |
Previous Message | Andreas | 2008-05-17 23:36:20 | How let client store stuff encypted ? |