From: | Lukas Eder <lukas(dot)eder(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: java.sql.ResultSet.getTime() returns wrong time |
Date: | 2010-09-20 16:58:40 |
Message-ID: | AANLkTi=mGx2hT65SEgkRKQB=a-cphdVGQ8FawMsKd3ry@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi folks,
Thanks for your feedback, guys. Tom, you're right, I would not have used
timetz, except for the fact, that the current_time returns exactly that. But
I guess, that's not a driver problem. So, Oliver, I understand your
argument, it sounds logical. I guess then, it's a feature, not a bug ;-)
Cheers
Lukas
2010/9/19 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Oliver Jowett <oliver(at)opencloud(dot)com> writes:
> > Did you see Kris's earlier response here? See
> > http://archives.postgresql.org/pgsql-jdbc/2010-05/msg00052.php. The
> > problem is we need to pass around a timezone offset, but JDBC +
> > java.util.Date give us no way to do that without subclassing those types
> > (which seems a bit hairy). Without that extra data, timetz just doesn't
> > map well to any of the standard Java date/time types.
>
> timetz is a fundamentally brain-dead data type to start with ---
> it simply doesn't carry enough information to deal with timezones
> meaningfully, at least not once you start considering DST changes.
> This is the SQL standard's fault not ours, so there's not a lot
> we can do about it other than recommend people avoid timetz.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Dekany | 2010-09-20 18:23:48 | Re: Bug? Reading items of array of composite a type |
Previous Message | Daniel Dekany | 2010-09-20 10:55:55 | Bug? Reading items of array of composite a type |