[Bug] Timezone offset bug in DateTimeUtils
- 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
Assessment
This issue has not been assessed yet.