Re: TimeStamp problem...

That's true!
Thank you!

>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: "Vitali Petrov" <vitalipetrov(at)hotmail(dot)com>
>CC: pgsql-jdbc(at)postgresql(dot)org
>Subject: Re: [JDBC] TimeStamp problem... Date: Tue, 21 Jan 2003 09:59:35
>-0500
>
>"Vitali Petrov" <vitalipetrov(at)hotmail(dot)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

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus