My typo. Converting java.sql.Timestamp to java.util.Date was buggy on
my end.
David
On Jun 10, 2009, at 1:00 PM, Kevin Grittner wrote:
David Leppik <dlep...@vocalabs.com> wrote:
Never mind. Turns out the bug was in our own code (read: me,
personally, being stupid) to convert a java.sql.Timestamp to
java.sql.Date. Why it works at all in MySQL... I don't even want
to know.
java.sql.Date or java.util.Date? (You don't show your imports, so
it's impossible to tell from the code snippet.) If it's
java.util.Date, I can't immediately see why your errors would be
greater than one second. If it's java.sql.Date, you're probably in
territory where the behavior is undefined, but it's hard to see where
you would get the results you showed. Perhaps there's an opportunity
for us to make the PostgreSQL JDBC driver behave more sanely in this
circumstance?
Why is it we can spend weeks looking at a bug, and we can't find
it until we decide to blame it on someone else?
It's probably a corollary to the tendency to see our own gaffs when
reading the post coming back from the list much more clearly than they
appeared before clicking "send". :-/
-Kevin
--
David Leppik
VP of Software Development
Vocal Laboratories, Inc.
dlep...@vocalabs.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs