Home > mailing lists

Time type error - Mailing list pgsql-jdbc

From	Alexaki Sofia
Subject	Time type error
Date	October 10, 2002 15:21:15
Msg-id	Pine.GSO.4.33.0210101910280.23600-100000@athena.ics.forth.gr Whole thread Raw
Responses	Re: Time type error
List	pgsql-jdbc

Tree view

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

pgsql-jdbc by date:

From: "G.Nagarajan"
Date: 10 October 2002, 14:45:42
Subject: Re: NullPointer error returned from ResultSet.java

From: Kevin Schmidt
Date: 10 October 2002, 15:47:28
Subject: JDBC MetaData Problem

Time type error - Mailing list pgsql-jdbc

Previous

Next