Problem when calling setObject on Timestamp column with JDBC driver - Mailing list pgsql-general

From Ian deSouza
Subject Problem when calling setObject on Timestamp column with JDBC driver
Date
Msg-id X3ff6.1400$yg1.168646@newsread2.prod.itd.earthlink.net
Whole thread Raw
List pgsql-general
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?



pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: RE: [NOVICE] RE: Sizing of LARGE databases.
Next
From: Wouter de Vries
Date:
Subject: Re: MS Access data to PostgrSQL data