Skip Menu |

This queue is for tickets about the DateTime-Format-ISO8601 CPAN distribution.

Report information
The Basics
Id: 57633
Status: rejected
Priority: 0/
Queue: DateTime-Format-ISO8601
People
Owner: Nobody in particular
Requestors: xavier.robin [...] bluewin.ch
Cc:
AdminCc:
Bug Information
Severity: Critical
Broken in: 0.07
Fixed in: (no value)

History Show all quoted text
  Wed May 19 10:37:58 2010 xavier.robin [...] bluewin.ch - Ticket created
Subject: Cannot parse dates like 2010-05-16 13:29:37.137915+00
Hello, PostgreSQL returns dates in ISO 8601 format such as 2010-05-16 13:29:37.137915+00. Unfortunately they are not recognized. DateTime::Format::ISO8601->parse_datetime('2010-05-16 13:29:37.137915+00'); Creates the following error: Invalid date format: 2010-05-16 13:29:37.137915+00 at [...] Perl v5.10.0 built for i486-linux-gnu-thread-multi On Linux debian/lenny 2.6.18-xenU #1 SMP Tue Nov 24 18:35:42 CET 2009 i686 GNU/Linux
  Wed May 19 11:03:12 2010 jhoblitt [...] cpan.org - Correspondence added
Per the ISO8601:2000 standard, the separator character is required. Thus "2010-05-16 13:29:37.137915+00" is not a valid ISO8601 format. As an example, "2010-05-16T13:29:37.137915+00" would be considered valid. I suggest that you look at either DateTime::Format::MySQL or define a time format string for Pg. -J --
  Wed May 19 11:03:13 2010 The RT System itself - Status changed from 'new' to 'open'
  Wed May 19 11:03:13 2010 jhoblitt [...] cpan.org - Status changed from 'open' to 'rejected'