Repository navigation
Does clickhouse jdbc preparedstatement support set timestamp with nanoseconds? #709
Description
clickhouse jdbc version: 0.3.1
The column type is datetime64(6) in my clickhouse table. I use the following code to set timestamp value. When I execute query I find the precision is not correct. Expected value is '2021-09-01 00:00:00.123456' and the actually value is '2021-09-01 00:00:00.123'.
value = '2021-09-01 00:00:00.123456'
pstmt.setObject(i, value);
Activity
zhicwu commentedon Aug 30, 2021
Sorry it does not work well at this point. Please refer to discussion in #608.
KaimingWan commentedon Aug 30, 2021
@zhicwu Thanks, I will pay attention to the latest clickhouse driver.
zhicwu commentedon Dec 29, 2021
Now it works in 0.3.2, but please consider to use setObject and LocalDateTime for better performance.