Problem when calling setObject on Timestamp column with JDBC driver

Поиск
Список
Период
Сортировка
Искать
От
Ian deSouza
Тема
Problem when calling setObject on Timestamp column with JDBC driver
Дата
Msg-id
X3ff6.1400$yg1.168646@newsread2.prod.itd.earthlink.net
Список
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 по дате отправления
От: Francisco Reyes
Дата:
От: Stephane Bortzmeyer
Дата:
FAQ