Skip to content

Conversation

askyx
Copy link
Contributor

@askyx askyx commented Jul 3, 2025

Inconsistent time zone between Postgres and DuckDB can lead to
unexpected results when performing some queries which use
timestamptz data type. To avoid this, we should keep time zone
same during execution.

@askyx
Copy link
Contributor Author

askyx commented Jul 3, 2025

this is fix for #852

@askyx askyx marked this pull request as draft July 3, 2025 15:09
@askyx askyx marked this pull request as ready for review July 4, 2025 12:56
Copy link
Collaborator

@JelteF JelteF left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks for your contribution! I left a few comments on how to reduce the amount of code for this.

Inconsistent time zone  between Postgres and DuckDB can lead
to unexpected results when performing some queries which use
timestamptz data type. To avoid this, we should keep time zone
is same during execution.
@JelteF JelteF merged commit 4a76ecb into duckdb:main Jul 10, 2025
7 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants