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
$d = date('Y-m-d H:i:sT', time());
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
host=> SELECT CAST('2008-05-21 23:04:24SGT' AS TIMESTAMP WITH TIME
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