Re: JDBC query result Date column get wrong value

Good sharing, thanks Yiming! 2016-07-21 8:01 GMT+08:00 Yiming Liu : > Following is the answer from Julian who is the core Calcite developer: > > "Calcite is implementing the SQL standard, which says that date-time > values have no time zone, and JDBC, which converts

Re: JDBC query result Date column get wrong value

it's not a Kylin bug, but from Calcite date processing. Has sent help request to Calcite community. Will update when get answer. 2016-07-20 15:14 GMT+08:00 Yiming Liu : > Hi Kylin devs, > > Running against the sample learn_kylin project on the latest master > branch:

JDBC query result Date column get wrong value

Hi Kylin devs, Running against the sample learn_kylin project on the latest master branch: select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales where part_dt = DATE'2012-01-01' group by part_dt order by part_dt; I got the result from Web GUI: