Problem when calling setObject on Timestamp column with JDBC driver
Ian deSouza <iand@metamousetrap.com>
From: "Ian deSouza" <iand@metamousetrap.com>
To: <pgsql-bugs@postgresql.org>
Date: 2001-02-06T16:38:39Z
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?