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

Time type error

From: Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: <pgsql-jdbc(at)postgresql(dot)org>, Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>
Subject: Time type error
Date: 2002-10-10 16:16:07
Message-ID: Pine.GSO.4.33.0210101910280.23600-100000@athena.ics.forth.gr (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-odbc
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


Responses

pgsql-odbc by date

Next:From: Dave CramerDate: 2002-10-10 23:07:32
Subject: Re: Time type error
Previous:From: Jean-Luc LachanceDate: 2002-10-10 16:12:11
Subject: Re: ROWID ? or other internal ID

pgsql-jdbc by date

Next:From: Barry LindDate: 2002-10-10 16:40:19
Subject: Re: Out of memory error on huge resultset
Previous:From: G.NagarajanDate: 2002-10-10 15:49:10
Subject: Re: NullPointer error returned from ResultSet.java

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