(If this is not the right place to report bugs, please correct me)
The contents of DATE and TIME fields read from Postgresql are displayed wrong.
System: Linux Fedora Core 18 - 64bit
KNIME: 2.7.4
Postgresql: 9.2.4
JDBC driver: postgresql-9.2-1002.jdbc3.jar
Table:
CREATE TABLE "EQ_NEIC"
(
"EQDATE" date,
"EQTIME" time without time zone,
);
Nodes where seen:
a) "Database Reader"
b) Combination of "Database Reader" and "Cache"
c) Combination of "Database Connector" and "Database Connection Reader"
Query:
select
"EQDATE",
"EQTIME"from "EQ_NEIC"
where
"EQDATE" = '2011-03-15'
and "EQTIME" >= '08:00:00'::TIME
and "EQTIME" < '09:00:00'::TIMEorder by
"EQDATE",
"EQTIME"
Results in Postgresql:
EQDATE | EQTIME
------------±------------
2011-03-15 | 08:01:43.76
2011-03-15 | 08:08:37.08
2011-03-15 | 08:11:47.7
2011-03-15 | 08:13:50.1
2011-03-15 | 08:16:59.52
2011-03-15 | 08:28:25.71
2011-03-15 | 08:36:21.6
2011-03-15 | 08:45:33.53
2011-03-15 | 08:46:35.53
2011-03-15 | 08:48:24.13
2011-03-15 | 08:56:41.87
(11 rows)
Results in KNIME:
EQDATE EQTIME
2011-03-14 07:01:43.760
2011-03-14 07:08:37.80
2011-03-14 07:11:47.700
2011-03-14 07:13:50.100
2011-03-14 07:16:59.520
2011-03-14 07:28:25.710
2011-03-14 07:36:21.600
2011-03-14 07:45:33.530
2011-03-14 07:46:35.530
2011-03-14 07:48:24.130
2011-03-14 07:56:41.870
Expected behavior: KNIME should not alter data on its own initiative.