On May 9, 2004, at 7:28 AM, Rick Measham wrote:
At 2:28 am -0700 2004-05-09, Jonah Petri wrote:* Did DateTime::TimeZone::offset_as_seconds at some point allow 2 digit offsets? (i can't find any evidence of this...)
Does ISO8601 allow for two digit offsets (which IIRC are hours-only)?
In lieu of the actual spec (you have to pay for it??), http://hydracen.com/dx/iso8601.htm indicates that they are legal.
Annoying though. I remember pre-datetime I used to SELECT to_char('YYYY-MM-DD', order_date) as order_date FROM blah which is not only annoying but silly.
**** While we're talking about Pg ****
I'd like to have a way of getting all data from Pg (and all DBDs) to pass DateTime objects rather than strings. Where should this be done?
I am using Class::DBI for a object abstraction layer from the DB. Among other really nice features, it lets you specify column inflation and deflation subs to go to/from DB and objects. The DT::F parse_foo() functions fit in here really well.
-Jonah
