Daisuke Maki <[EMAIL PROTECTED]> schrieb/wrote: > my installation of Postgres, which had a default setting as far as time > zones come, prints out time offsets in the form of +09, not +0900, so > this was causing problems.
Strange. I thought that problem had already been fixed (in DateTime::TimeZone::offset_as_seconds) some time ago. Obviously that only applies to seconds (i.e. +12:34:00 vs. +12:34). > I don't know what the best solution is (fix datetime.pm so that it > accepts +09? fix Pg.pm else where?), but here's a hack that worked for > me: AFAIR the consensus wrt the seconds problem was to fix DT::TZ. However, that was some time ago; in the meantime, the installed base of older DateTime versions justifies to change DateTime::Format::Pg. I've just uploaded DateTime-Format-Pg 0.07, which corrects the problem. However, it might be a good idea to also add the little "?" to the regexps in DateTime::TimeZone::offset_as_seconds. Claus -- http://www.faerber.muc.de
