Bug #87550 for DateTime-Format-CLDR: Bad parsing of 24 hour

Fri Aug 02 09:30:55 2013 gonzalo.mateo [...] meteologica.com - Ticket created

Subject:	Bad parsing of 24 hour
Date:	Fri, 2 Aug 2013 15:30:40 +0200
To:	bug-DateTime-Format-CLDR [...] rt.cpan.org
From:	Gonzalo Mateo <gonzalo.mateo [...] meteologica.com>

Dear Sir or Madam, We have detected a problem while parsing csv files with dates in the following format: ... 2013.07.21 23:45:00 2013.07.21 24:00:00 2013.07.21 00:15:00 2013.07.21 00:30:00 2013.07.21 00:45:00 ... We found out that if we parse those dates with pattern 'yyyy.MM.dd HH:mm:ss' when it comes to date with hour 24, it parses the date with hour and minute: 02:40. It does this transformation without giving warning message or failing. Code: my $cldr = new DateTime::Format::CLDR( pattern => 'yyyy.MM.dd HH:mm:ss', time_zone => 'Europe/Madrid', ); print $cldr->parse_datetime("2013.07.21 24:00:00")."\n"; Output: 2013-07-21T02:40:00 We attach a complete version of the script with the output produced. We wonder if there is a way to get around this problem that does not imply manual pre-processing the dates. If you require any further information, feel free to contact me. Thank you in advance for your help, Yours faithfully ========================================== Gonzalo Mateo García Meteologica SA C. Heliotropo, 5 28029 Madrid gonzalo.mateo@meteologica.com ==========================================

Message body is not shown because sender requested not to inline it.

Thu Aug 15 15:31:12 2013 MAROS [...] cpan.org - Correspondence added

Should be fixed in 1.15

Thu Aug 15 15:31:13 2013 The RT System itself - Status changed from 'new' to 'open'

Thu Aug 15 15:31:13 2013 MAROS [...] cpan.org - Status changed from 'open' to 'resolved'

Mon Sep 02 04:46:14 2013 gonzalo.mateo [...] meteologica.com - Correspondence added

Subject:	Re: [rt.cpan.org #87550] Bad parsing of 24 hour
Date:	Mon, 2 Sep 2013 10:45:59 +0200
To:	bug-DateTime-Format-CLDR [...] rt.cpan.org
From:	Gonzalo Mateo <gonzalo.mateo [...] meteologica.com>

Thank you very much Maros (Sorry for the late respond I was on holiday) ========================================== Gonzalo Mateo García Meteologica SA C. Heliotropo, 5 28029 Madrid Tel. +34 914 561 001 ext. 137 Fax. +34 914 561 002 gonzalo.mateo@meteologica.comwww.meteologica.com ========================================== LOPD y LSSI De acuerdo con la legislación vigente en materia de Protección de Datos de Carácter Personal (Ley 15/1999 del 13 de Diciembre), le informamos que su dirección de correo electrónico y los mensajes que pudiéramos recibir, pasarán a formar parte de un fichero denominado EMAILS, del que es responsable Meteológica, S.A. Puede ejercer sus derechos de acceso, cancelación, modificación y oposición en la dirección postal C/ Heliotropo, 5 bajo, 28029 – Madrid Telf. 914 561 001 Fax 914 561 002. La finalidad de éste fichero es la de realizar una correcta gestión y prestación de los servicios ofrecidos por Meteológica, S.A. a sus clientes, no cediéndose en ningún momento los datos facilitados. Show quoted text

________________________________________________________________ 2013/8/15 Maroš Kollár via RT <bug-DateTime-Format-CLDR@rt.cpan.org>

> <URL: https://rt.cpan.org/Ticket/Display.html?id=87550 > > > Should be fixed in 1.15 >