From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pgsql's datetime perl equivalent ? |
Date: | 2001-12-17 01:56:38 |
Message-ID: | E16Fn1B-0001PA-00@blount.mail.mindspring.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
-----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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200112162039
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html
iD8DBQFyqV9gvJuQZxSWSsgRAhtpAKCxCr1+jnNPOHXd4c0kGQTSDWJVWACg/t16
Sdw0ayy+FfS0Bueywx0SvHc=
=qETw
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Harvey | 2001-12-17 02:03:21 | ODBC on OSX |
Previous Message | Tom Lane | 2001-12-17 01:47:24 | Re: [HACKERS] unexpected SIGALRM |