New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Write a documentation page describing how Chronify supports time. #7

Open

daniel-thom opened this issue Oct 18, 2024 · 1 comment

Assignees

Collaborator

daniel-thom commented Oct 18, 2024

Acceptance Criteria:

Defines supported time types (datetime, representative time, annual time, etc.)
Defines how input time zones are supported, including whether timestamps can be time zone naive.
Defines how time configurations can be mapped, including time zones.
Defines how time zones are either supported or not supported for different backends (DuckDB, Spark, SQLite, etc.).

daniel-thom assigned lixiliu

Collaborator Author

daniel-thom commented Oct 18, 2024

User passes timezone aware timestamps. We convert to UTC and strip the time zone.
User passes timezone unaware timestamps and the time zone in the schema. Timestamps may be implicit by time-array row index.
User passes timezone unaware timestamps and a separate mapping of time-array-id to time zone.

We will not support day/hour database extraction based on non-standard time zones.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment