Can anybody show any reason why the code using a prepared statement with a where clause using a date won't find any records on PostgreSQL but WILL work using Access and the jdbc-odbc bridge? ie. 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-05 00:00:00.0 It does not cause an exception, but fails to retrieve anything with PostgreSQL yet works and retrieves the right record with Access. I further verified that a record does exist with the PostreSQL database.
