Mike Rylander writes: > [UPDATE] While my coworker was investigating the problem > described above further, I've developed (and attached) a patch to > dbd_helper.c to parse ISO8601 timezone offsets inside > _dbd_parse_datetime() if they happen to occur. I use Postgres as my > main database, and this allows me to use TIMESTAMP WITH TIME ZONE > columns and get the correct date and time out, without having to > mangle the timezone on the system (or inside the database) to assume > UTC. It is untested with other databases, but it's fairly protective, > looking for specific timezone markers, and should be able to handle > any standard ISO timezone offset. >
While the supplied patch appears to work ok for TIMESTAMP WITH TIME ZONE columns, I had a problem with TIME WITH TIME ZONE columns. Turns out that the pgsql driver did not handle this column type correctly. I've fixed this here, but I'll run a few more tests to make sure all is fine now. I guess I'll be able to check in the changes tomorrow. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users