PSQL emulation layer has problems converting timestamp '0000 ------------------------------------------------------------ Key: TEIID-1928 URL: https://issues.jboss.org/browse/TEIID-1928 Project: Teiid Issue Type: Bug Affects Versions: 7.6 Environment: java version "1.6.0_20" OpenJDK Runtime Environment (IcedTea6 1.9.10) (rhel-1.23.1.9.10.el5_7-x86_64) OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode) on Red Hat Enterprise Linux Server Teiid 7.6 Perl client running on either Fedora 16 or RHEL 5.7 Using perl-DBD-Pg-2.18.0-3.fc16.x86_64 Reporter: Graeme Gillies Assignee: Steven Hawkins When we attempt to run the following query against our teiid 7.6 install we get an error about converting timestamps. Note this only seems to affect the PSQL emulation layer, jdbc layer is fine {noformat} EngVDBF=> select * from orgchart2s.history; ERROR: Error Code:S1009 Message:OrgChart2DS: Error Code:S1009 Message:Unexpected exception while translating results: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP. DETAIL: org.teiid.jdbc.TeiidSQLException: Error Code:S1009 Message:OrgChart2DS: Error Code:S1009 Message:Unexpected exception while translating results: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP. EngVDBF=> {noformat} It looks like there is a problem converting a timestamp of '0000-00-00 00:00:00'