Problem when calling setObject on Timestamp column with JDBC driver

Поиск
Список
Период
Сортировка
От Ian deSouza
Тема Problem when calling setObject on Timestamp column with JDBC driver
Дата
Msg-id 000e01c0905c$1c3a07d0$65646464@ian
обсуждение исходный текст
Список 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?

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Max Vaschenko
Дата:
Сообщение: BUG or feature?
Следующее
От: Nat Howard
Дата:
Сообщение: 7.1beta4 problem on freebsd 4.2 with JSDK 1.1.8.