Hi Calcite devs,
I was using Kylin 1.5.2.1 JDBC Driver which is based on Calcite 1.6. I try
to retrieve a Date column. The origin Date is '2012-01-01', but when I
called the rs.getString('dateColumn'), I got '2011-12-31'.
I tried to debug this problem. There are some unix timestamp convert, and
timezone offset shift in Calcite. It's a little complicated there and found
no test cases related(for DateTimeUtils). The original '2012-01-01' has
unix timestamp 1325347200000, but from the client side,
rs.getDate('dateColumn').getTime() returns 1325318400000. The timestamp
changed. My timezone is GMT+8.
I'm not sure if it is an issue or some configuration I need to set first
when using Calcite.
--
With Warm regards
Yiming Liu (刘一鸣)
