Bad doc for SAMPLE BY ALIGN TO CALENDAR with Timezone

Open Beginner friendly
#126 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
2/5
Estimated time
1-3 hours
Newbie friendliness
78/100
Issue type
Documentation
Clarity
Clearly specified
Activity status
Active
Tech stack
sql
Domain
documentation

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.

Description

bug documentation

This section is incorrect: https://questdb.com/docs/reference/sql/sample-by/#time-zone

Image

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:

Image

Dominant language
TypeScript
Stars
13
Forks
44
Avg merge
1d 9h
Merged PRs (30d)
26

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from questdb/documentation

All issues in questdb/documentation

Similar issues

More TypeScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.