questdb / questdb/documentation
Bad doc for SAMPLE BY ALIGN TO CALENDAR with Timezone
Nobody has claimed this yet.
- Dominant language
- TypeScript
- Stars
- 13
- Forks
- 44
- Avg merge
- 1d 9h
- Merged PRs (30d)
- 26
Description
This section is incorrect: https://questdb.com/docs/reference/sql/sample-by/#time-zone
The examples shows sample-by-1-day query aligned to the Berlin timezone. It displays the results in UTC. In this case the displayed buckets should start at 10pm. Since 10pm UTC is midnight in Berlin (during DST) However, the docs show the timestamps starts at 1am UTC. This is wrong.
The actual QuestDB server behaviour is correct, it looks like a docs-only issue:
Contributor guide
No contributing guide indexed for this repository
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.
Research direction
Start at the linked SAMPLE BY documentation section, especially the “Time zone” example, and compare its displayed bucket timestamps with the reported QuestDB server behavior for Berlin time. Update the documented example so the UTC timestamps correctly represent the Berlin-aligned daily buckets, then verify the surrounding explanation remains consistent.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- documentation
- Issue type
- Documentation
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Active
- Clarity
- Clearly specified
- Newbie friendliness
- 78/100