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