Re: Time type error

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" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Time type error
Date: 2002-10-10 23:07:32
Message-ID: 1034291253.1893.42.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-odbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2002-10-11 00:35:37 Re: Taking advantage of prepared statement performance
Previous Message Brett 2002-10-10 18:39:50 Re: Taking advantage of prepared statement performance

Browse pgsql-odbc by date

  From Date Subject
Next Message Ben Litchfield 2002-10-12 16:23:28 ODBC Driver extremly slow on winxp
Previous Message Alexaki Sofia 2002-10-10 16:16:07 Time type error