Skip to content

Conversation

hawkfish
Copy link
Contributor

@hawkfish hawkfish commented Sep 9, 2024

TIMETZ => TIME => TIMETZ does not round trip because the first cast loses the offset. The reverse does round trip because the offset will be 0.

fixes: #13813
fixes: duckdblabs/duckdb-internal#2986

TIMETZ => TIME => TIMETZ does not round trip because the first cast loses the offset.
The reverse does round trip because the offset will be 0.

fixes: duckdb#13813
fixes: duckdblabs/duckdb-internal#2986
Copy link
Contributor

@Tmonster Tmonster left a comment

Choose a reason for hiding this comment

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

lgtm!

@Mytherin Mytherin merged commit 8d1c2b2 into duckdb:main Sep 10, 2024
41 checks passed
@Mytherin
Copy link
Collaborator

Thanks!

@hawkfish hawkfish deleted the timetz-invertible branch September 11, 2024 17:00
github-actions bot pushed a commit to duckdb/duckdb-r that referenced this pull request Sep 25, 2024
Merge pull request duckdb/duckdb#13820 from hawkfish/timetz-invertible
github-actions bot added a commit to duckdb/duckdb-r that referenced this pull request Sep 25, 2024
Merge pull request duckdb/duckdb#13820 from hawkfish/timetz-invertible

Co-authored-by: krlmlr <krlmlr@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Unexpected result when using IN with TIME values
3 participants