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)



MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 581
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)
MIME-Version: 1.0
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-10497-1322178837-735.72706-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 287
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
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-10497-1322178837-735.72706-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <rt-3.8.HEAD-10497-1322178837-735.72706-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-6890-1322179832-973.72706-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
From: rod.taylor [...] gmail.com
X-RT-Original-Encoding: utf-8
Content-Length: 223
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.
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-6890-1322179832-973.72706-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <rt-3.8.HEAD-10497-1322178837-735.72706-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-6890-1322179832-973.72706-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-6890-1322180535-101.72706-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 27
Thanks, released as 0.16007
MIME-Version: 1.0
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-6892-1322185033-42.72706-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 15
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.