duckdb / duckdb/duckdb-java

TIMESTAMP_NS nanoseconds are truncated

Open
#571 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
127
Forks
80
Avg merge
13h 49m
Merged PRs (30d)
48

Description

E.g.
```(java)
java.sql.Timestamp ts = new java.sql.Timestamp(millis);
ts.setNanos(123456789);
ps.setTimestamp(1, ts); // column 1 has type TIMESTAMP_NS
```
DuckDBTimestamp converts the Timestamp to micros and as result nanosecond part (`789` from the example) is not stored.

The same happens on reading the value back

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.