Re: TimeStamp problem...

"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