Doc of Influxdb 3 core should mention that the client gets a java.time.LocalDateTime without time zone information through /api/v3/query_sql

[linghengqian]

• Doc of Influxdb 3 core should mention that the client gets a java.time.LocalDateTime without time zone information through /api/v3/query_sql.
• The current documentation for Influxdb 3 core barely mentions a java-specific scenario.
• When I tested the SQL select time,location,value from home order by time desc limit 10 for /api/v3/query_sql in https://github.com/linghengqian/influxdb-3-core-jdbc-test/blob/master/src/test/java/io/github/linghengqian/TimeDifferenceTest.java , I found that I got a java.time.LocalDateTime. When inserting data into influxdb 3 core, java.time.Instant is often used.

private final Instant magicTime = Instant.now().minusSeconds(10);

@Container
private final GenericContainer<?> container = new GenericContainer<>("quay.io/influxdb/influxdb3-core:911ba92ab4133e75fe2a420e16ed9cb4cf32196f")
            .withCommand("serve --node-id local01 --object-store memory")
            .withExposedPorts(8181);

private void queryDataByHttp() throws URISyntaxException, IOException, InterruptedException {
        URI uri = new URIBuilder().setScheme("http")
                .setHost(container.getHost())
                .setPort(container.getMappedPort(8181))
                .setPath("/api/v3/query_sql")
                .setParameter("db", "mydb")
                .setParameter("q", "select time,location,value from home order by time desc limit 10")
                .build();
        HttpResponse<String> response = HttpClient.newHttpClient()
                .send(HttpRequest.newBuilder().uri(uri).GET().build(), BodyHandlers.ofString());
        assertThat(
                new ObjectMapper().readTree(response.body()).get(0).get("time").asText(),
                is(magicTime.atOffset(ZoneOffset.UTC).toLocalDateTime().toString())
        );
    }

• I think such a big difference should be properly mentioned in the document.

[jstirnaman]

@jeffreyssmith2nd This isn't specific to Core, is it?

[jeffreyssmith2nd]

@mgattozzi or @hiltontj would know better than me, I'm not familiar with the /v3 apis.

[mgattozzi]

I think this might be a follow up to this if more context is needed

influxdata/influxdb#25983

[hiltontj]

@linghengqian - would you mind pointing out which document you are referring to?

[linghengqian]

@linghengqian - would you mind pointing out which document you are referring to?

• I'm mainly referring to https://docs.influxdata.com/influxdb3/core/query-data/sql/ documentation. This document only mentions some information for influxdb 3 golang client, but lacks information for java client and arrow flight java api.
•