Problem when calling setObject on Timestamp column with JDBC driver

From: "Ian deSouza" <iand(at)metamousetrap(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem when calling setObject on Timestamp column with JDBC driver
Date: 2001-02-06 16:38:39
Message-ID: 000e01c0905c$1c3a07d0$65646464@ian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I'm having a problem doing a select on an Order with a where clause below,
getting a preparedStatemtnt and calling
preparedStatement.setObject(timeStamp);

Its return nothing and I know there is a row with that orderDate.

SQL: select
OrderID,CustomerID,EmployeeID,OrderDate,RequiredDate,ShippedDate,ShipVia,Fre
ight,ShipName,ShipAddress,ShipCity,ShipRegion,ShipPostalCode,ShipCountry
from Orders where OrderDate=?
Setting value: OrderDate 1996-07-07 23:00:00.0

Could there be a bug here?

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2001-02-06 16:43:16 Re: [HACKERS] Re: syslog logging setup broken?
Previous Message Tom Lane 2001-02-06 16:01:11 Re: UNION and VIEW