Skip to content
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.

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

to_unixtime does not support timestamps with a timezone #14488

Open
Omega359 opened this issue Feb 4, 2025 · 1 comment · May be fixed by #14490
Open

to_unixtime does not support timestamps with a timezone #14488

Omega359 opened this issue Feb 4, 2025 · 1 comment · May be fixed by #14490
Assignees
Labels
bug Something isn't working

Comments

@Omega359
Copy link
Contributor

Omega359 commented Feb 4, 2025

Describe the bug

Somewhat related to #12892 but different. The following query fails in DF 45:

select to_unixtime(arrow_cast(to_timestamp('2023-01-14T01:01:30'), 'Timestamp(Second, Some("+05:30"))'));

The issue is in invoke_batch where it will match only DataType::Timestamp(_, None), not DataType::Timestamp(_, tz)

To Reproduce

Run sql.

Expected behavior

to_unixtime should work regardless of whether a tz was provided or not

Additional context

No response

@Omega359 Omega359 added the bug Something isn't working label Feb 4, 2025
@Omega359
Copy link
Contributor Author

Omega359 commented Feb 4, 2025

take

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant