"Vitali Petrov" <vitalipetrov@hotmail.com> writes:
> 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"
Since the complaint is coming from pg_atoi, it would seem that this
string is being fed to an integer column, not a timestamp column at
all. Check your SQL...
regards, tom lane