| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Sergio_Lob(at)iwaysoftware(dot)com |
| Cc: | pgsql-jdbc(at)postgresql(dot)org, Ephraim_Spravtsev(at)iwaysoftware(dot)com |
| Subject: | Re: [BUGS] BUG #1523: precision column value returned from |
| Date: | 2005-03-09 21:10:25 |
| Message-ID: | 422F6641.6030806@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-jdbc |
Sergio Lob wrote:
> What format does PostgreSQL return in getString() method for a timestamp column, for example? Seems like it should return same as toString() method of a timestamp object as defined in java 2 api spec.
It returns the string representation the backend gave it. This is true
for all types at the moment. For a timestamp with timezone value this is
generally going to be yyyy-mm-dd hh:mm:ss.nnnnnnzzz:
test=# select now();
now
-------------------------------
2005-03-10 10:08:11.707753+13
(1 row)
Does the JDBC spec say somewhere that we should return a different format?
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-09 23:40:47 | Re: BUG #1528: Rows returned that should be excluded by WHERE clause |
| Previous Message | Sergio Lob | 2005-03-09 18:21:18 | Re: [BUGS] BUG #1523: precision column value returned from |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ryszard Lach | 2005-03-09 21:15:22 | PostgreSQL 8.0 can't print duration in log when client uses 8.0 jdbc driver |
| Previous Message | Mican Bican | 2005-03-09 19:08:01 | Re: java is locked when select for update |