Received: from blount.mail.mindspring.net (blount.mail.mindspring.net [207.69.200.226]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBH1ucm49799 for ; Sun, 16 Dec 2001 20:56:38 -0500 (EST) (envelope-from greg@turnstep.com) Received: from user-2inibus.dialup.mindspring.com ([165.121.47.220] helo=mindspring.com) by blount.mail.mindspring.net with smtp (Exim 3.33 #1) id 16Fn1B-0001PA-00; Sun, 16 Dec 2001 20:56:38 -0500 From: "Greg Sabino Mullane" To: pgsql-hackers@postgresql.org Subject: Re: pgsql's datetime perl equivalent ? X-Echelon: AIDS hgI World Bank CIA Germany C4 Gaddafi Tony Blair NSA war Afghan rebels hOA Date: Tue, 17 Dec 2030 01:52:07 -0000 X-Mailer: GregMail 1.42 Message-Id: X-Archive-Number: 200112/493 X-Sequence-Number: 16638 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > 'Mon, 23 Nov 1998 08:37:16 -5:00' if fine for postgresql but > produces error in Date::Parse :-) Date::Parse is not parsing it because of your timezone: "-5:00" is not legal; according to ISO 8601 it should be one of: +HH:MM, +HH, -HH:MM, -HH (see the TIMEZONES section in perldoc Date::Manip for a complete list) Just add a zero before the five and Date::Manip and postgresql will be more than happy to play with the date. Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200112162039 -----BEGIN PGP SIGNATURE----- Comment: http://www.turnstep.com/pgp.html iD8DBQFyqV9gvJuQZxSWSsgRAhtpAKCxCr1+jnNPOHXd4c0kGQTSDWJVWACg/t16 Sdw0ayy+FfS0Bueywx0SvHc= =qETw -----END PGP SIGNATURE-----