public inbox for [email protected]
help / color / mirror / Atom feedpgsql's datetime perl equivalent ?
2+ messages / 2 participants
[nested] [flat]
* pgsql's datetime perl equivalent ?
@ 2001-12-16 22:10 Oleg Bartunov <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Oleg Bartunov @ 2001-12-16 22:10 UTC (permalink / raw)
To: [email protected]; pgsql-hackers
Thomas,
do you know if there are perl equivalent for datetime validity check ?
I use Date::Parse to validate datetime stuff I insert into postgresql,
but seems postgres is smarter. For example,
'Mon, 23 Nov 1998 08:37:16 -5:00' if fine for postgresql but
produces error in Date::Parse :-)
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [email protected], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgsql's datetime perl equivalent ?
@ 2030-12-17 01:52 Greg Sabino Mullane <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Greg Sabino Mullane @ 2030-12-17 01:52 UTC (permalink / raw)
To: 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
[email protected]
PGP Key: 0x14964AC8 200112162039
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html
iD8DBQFyqV9gvJuQZxSWSsgRAhtpAKCxCr1+jnNPOHXd4c0kGQTSDWJVWACg/t16
Sdw0ayy+FfS0Bueywx0SvHc=
=qETw
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2030-12-17 01:52 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-12-16 22:10 pgsql's datetime perl equivalent ? Oleg Bartunov <[email protected]>
2030-12-17 01:52 Re: pgsql's datetime perl equivalent ? Greg Sabino Mullane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox