Bad Timestamp Format Error
От | Paul Stead |
---|---|
Тема | Bad Timestamp Format Error |
Дата | |
Msg-id | BNENLMOEFCOIEGKDJMLLKEHHCBAA.pstead@elementallogic.com обсуждение исходный текст |
Ответы |
Re: Bad Timestamp Format Error
|
Список | pgsql-jdbc |
Hi all, I'm writing a Java program that uses JDBC to extract data from existing databases, one of which is PostgreSQL. When it tries to read a timestamp created using NOW() from the postgreSQL database, it throws an exception. If I enter the time manually such that there are no nanoseconds it works fine. So if I set datebegin using NOW(), it looks something like: 2002-07-31 09:18:01.414573-07 and when I use this Java statement: campaign.setStart( sqlResults.getTimestamp(4).getTime() ); where campaign.setStart looks like: public void setStart(long useDate) { begin = new Date(useDate); } I get the exception: Bad Timestamp Format at 23 in 2002-07-31 09:18:01.414573-07 However, if I set datebegin as: 2002-07-31 09:18:01-07 it works fine.... Any ideas on how to get around this??? The database used NOW() for timestamps throughout, so nanoseconds are everywhere. thanks in advance, Paul
В списке pgsql-jdbc по дате отправления: