TIMETRUNCATE(_ts, 1d) gives wrong output 2025-08-26T01:12:43.673112282+05:30 -> 2025-08-26T00:30:00.000000000+05:30
Open
@yu285 is already working on this.
Since Aug 31, 2025.
bug
- Dominant language
- C
- Stars
- 25.1k
- Forks
- 5k
- Avg merge
- 4d 59m
- Merged PRs (30d)
- 7
Description
Bug Description
Issue is with TIMETRUNCATE(_ts, 1d)
gives wrong output except first row
2025-08-26T01:12:43.673112282+05:30 -> 2025-08-26T00:30:00.000000000+05:30
for query select _ts, TIMETRUNCATE(_ts, 1d) from trading.NSECM:NIFTY 50
Screenshots
Environment (please complete the following information):
- OS: Fedora 42 desktop gnmoe
- Memory: 16GB, CPU: i7-11th gen, current Disk Space: 100 GB free
- TDengine Version [e.g. 3.3.7]
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.