Re: 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
>
>