Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

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

Report information
The Basics
Id: 72706
Status: resolved
Priority: 0/
Queue: DateTime-Format-Pg

People
Owner: Nobody in particular
Requestors: rod.taylor [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.16006
Fixed in: (no value)



Download (untitled) / with headers
text/plain 581b
Timezones with minute and second offsets cause DateTime::Format::Pg to throw an error and PostgreSQL will happily hand them out, accept them back, and do proper time math with them. Snippets from psql: rbt=# set timezone = 'America/Toronto'; SET rbt=# select '1894-01-01'::timestamp with time zone; timestamptz ------------------------------ 1894-01-01 00:00:00-05:17:32 (1 row) rbt=# select '1894-01-01 00:00:00-05:17:32'::timestamp with time zone + interval '100 years'; ?column? ------------------------ 1994-01-01 00:00:00-05 (1 row)
Download (untitled) / with headers
text/plain 287b
Hi, Thanks for the report. Can you please try the latest version from the repo and see if it's fixed? https://github.com/lestrrat/DateTime-Format-Pg FYI, this is the relevant change: https://github.com/lestrrat/DateTime-Format- Pg/commit/dc23589b59fc2f57fe5975a36975219b688475e0 --d
From: rod.taylor [...] gmail.com
Download (untitled) / with headers
text/plain 223b
On Thu Nov 24 18:53:57 2011, DMAKI wrote: Show quoted text
> Hi, > > Thanks for the report. Can you please try the latest version from the > repo and see if it's fixed?
That seems to have done it. Thank-you for a very fast turnaround.
Thanks, released as 0.16007
forgot to close


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.