-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I get the following when trying to getTimestamp():
java.sql.SQLException: SERRORC22008Mtimestamp out of range: "292278994-08-17
07:12:55.807000+01"Ftimestamp.cL328Rtimestamptz_in
nbeweb=# select COALESCE(a.valid_from, a.created) from on_article a where a.id
= 510;
coalesce
- ---------------------------
2002-05-03 10:13:21.16+02
nbeweb=# select valid_from , created from on_article where id = 510;
valid_from | created
- ------------+---------------------------
| 2002-05-03 10:13:21.16+02
both fields are timestamp with time zone.
btw: What's up with the funny formatting of the error in the Exception?
JDK: 1.4.2
OS: Linux(mdk-9.0)
Postgresql: 7.4beta1
- --
Andreas Joseph Krogh <andreak@officenet.no>
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
- - When there is no content, there is no crap.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE/ON6EUopImDh2gfQRAgOnAJwKWuyckdEXHfbbNXCt8smVWb2gkwCdFUT4
Lb4iZxJhB0+cbfWb3bZXdUM=
=H8K9
-----END PGP SIGNATURE-----