Skip site navigation (1) Skip section navigation (2)

Re: Time type error

From: "Peter Kovacs" <peter(dot)kovacs(at)sysdata(dot)siemens(dot)hu>
To: "Dave Cramer" <Dave(at)micro-automation(dot)net>,"Alexaki Sofia" <alexaki(at)ics(dot)forth(dot)gr>
Cc: <pgsql-odbc(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Time type error
Date: 2002-10-14 08:00:17
Message-ID: 022e01c27357$bf83cc70$55550a8b@ACER (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-odbc
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)



In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2002-10-15 10:17:43
Subject: Re: Unix build
Previous:From: Ben LitchfieldDate: 2002-10-12 16:23:28
Subject: ODBC Driver extremly slow on winxp

pgsql-jdbc by date

Next:From: Peter KovacsDate: 2002-10-14 09:05:01
Subject: Re: [GENERAL] Prepared statement performance...
Previous:From: TobyDate: 2002-10-14 07:59:50
Subject: Re: [GENERAL] Prepared statement performance...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group