Re: TimeStamp problem...

"Vitali Petrov" <vitalipetrov@xxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster