Re: Time type error

This is really a fantastic example. Just make sure not to mistake
PreparedStatement(s) for prepared statement(s), because they are not the
same (as we learned it from Barry a few days ago).

----- Original Message -----
From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
To: "Alexaki Sofia" <alexaki(at)ics(dot)forth(dot)gr>
Cc: <pgsql-odbc(at)postgresql(dot)org>; <pgsql-jdbc(at)postgresql(dot)org>
Sent: Friday, October 11, 2002 1:07 AM
Subject: Re: [JDBC] Time type error

> This is a fantastic example of why to use prepared statements, just use
> a preparedstatement and use setTime the driver will take care of it for
> you.
>
> Dave
> On Thu, 2002-10-10 at 12:16, Alexaki Sofia wrote:
> > Hello,
> >
> > I am using PostgreSQL 7.2.1, and I am using JDBC interface
> > to store the data in the db.
> >
> > I have created a table with a field of "time".
> > However when I try to insert a time value with a time zone I get the
error
> > ERROR: Bad time external representation '16:20:00 +04:00'
> >
> > None of the following values seems to be valid
> > '16:20:00+04' '16:20:00 +04' '16:20:00 +04:00' '16:20:00+04:00'
> >
> > Is there any bug in PostgreSQL in handling the type time?
> >
> > thanks in advance,
> > Sofia Alexaki
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)