Thread: Time type error

Time type error

From
Alexaki Sofia
Date:
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


Re: Time type error

From
Dave Cramer
Date:
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
>
>




Re: Time type error

From
"Peter Kovacs"
Date:
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@micro-automation.net>
To: "Alexaki Sofia" <alexaki@ics.forth.gr>
Cc: <pgsql-odbc@postgresql.org>; <pgsql-jdbc@postgresql.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@postgresql.org)