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,
pgsql-odbc by date
|Next:||From: Dave Cramer||Date: 2002-10-10 23:07:32|
|Subject: Re: Time type error|
|Previous:||From: Jean-Luc Lachance||Date: 2002-10-10 16:12:11|
|Subject: Re: ROWID ? or other internal ID|
pgsql-jdbc by date
|Next:||From: Barry Lind||Date: 2002-10-10 16:40:19|
|Subject: Re: Out of memory error on huge resultset|
|Previous:||From: G.Nagarajan||Date: 2002-10-10 15:49:10|
|Subject: Re: NullPointer error returned from ResultSet.java|