Timestamp out of range Exception with jdbc-driver from 7.4-beta1
От | Andreas Joseph Krogh |
---|---|
Тема | Timestamp out of range Exception with jdbc-driver from 7.4-beta1 |
Дата | |
Msg-id | 200308121433.08645.andreak@officenet.no обсуждение исходный текст |
Ответы |
Re: Timestamp out of range Exception with jdbc-driver from
|
Список | pgsql-jdbc |
-----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-----
В списке pgsql-jdbc по дате отправления: