Singapore time zone

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.

Responses

Browse pgsql-novice by date

  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 ?