TimeStamp problem...
От | Vitali Petrov |
---|---|
Тема | TimeStamp problem... |
Дата | |
Msg-id | F63AB4zss2UmFlzNF0q000059af@hotmail.com обсуждение исходный текст |
Ответы |
Re: TimeStamp problem...
|
Список | pgsql-jdbc |
Then I insert new values with timestamp into table I get an error: Can anyone tell why? Code: PreparedStatement newPStat ... newPStat.setTimestamp(1, Timestamp.valueOf("2003-01-21 12:25:14")); newPStat.executeUpdate(); Error: java.sql.SQLException: ERROR: pg_atoi: error in "2003-01-21 12:25:14.000000+02": can't parse "-01-21 12:25:14.000000+02" at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197) at rendifirma.RendiaktidTableModel.insertNewRow(RendiaktidTableModel.java:131) Thanks. _________________________________________________________________ MSN 8: advanced junk mail protection and 2 months FREE*. http://join.msn.com/?page=features/junkmail
В списке pgsql-jdbc по дате отправления: