apache / apache/iotdb

[Bug] Timezone offset bug in DateTimeUtils

Open
#17,433 1 comment 1 reaction 1 assignee Claimed by @Lexert19 View on GitHub
Dominant language
Java
Stars
6.4k
Forks
1.2k
Avg merge
1d 23h
Merged PRs (30d)
115

Description

### Search before asking

- [x] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.

### Version

c91688bd47

### Describe the bug and provide the minimal reproduce step

The core issue lies in org.apache.iotdb.db.utils.datetimeutils.DateTimeUtils.toZoneOffset(ZoneId zoneId). This method calculates the timezone offset using Instant.now(). In regions that observe Daylight Saving Time (DST), such as Europe/Warsaw, the offset is not constant throughout the year (+1 in winter, +2 in summer).
timezone: Europe/Warsaw
INSERT INTO root.test.d1(time, s1) VALUES(2024-01-01T00:00:00, 1);
SELECT s1 FROM root.test.d1;

### What did you expect to see?

2024-01-01T00:00:00+01:00

### What did you see instead?

2023-12-31T23:00:00.000+01:00

### Anything else?

_No response_

### Are you willing to submit a PR?

- [x] I'm willing to submit a PR!

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.