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

bug(bigquery): time literal does not include microseconds in compiled SQL #9609

Closed
1 task done
tswast opened this issue Jul 16, 2024 · 0 comments · Fixed by #9610
Closed
1 task done

bug(bigquery): time literal does not include microseconds in compiled SQL #9609

tswast opened this issue Jul 16, 2024 · 0 comments · Fixed by #9610
Labels
bug Incorrect behavior inside of ibis

Comments

@tswast
Copy link
Collaborator

tswast commented Jul 16, 2024

What happened?

import datetime

import ibis

ibis.__version__
# '9.1.0'

literal = ibis.literal(datetime.time(12, 34, 56, 789101))
literal
# datetime.time(12, 34, 56, 789101)

type(literal)
# ibis.expr.types.temporal.TimeScalar

ibis.to_sql(literal, dialect="bigquery")
# SELECT time(12, 34, 56) AS `datetime_time_12_34_56_789101`

ibis.to_sql(literal, dialect="duckdb")
# SELECT MAKE_TIME(12, 34, 56.789101) AS "datetime.time(12, 34, 56, 789101)"

What version of ibis are you using?

9.1.0

What backend(s) are you using, if any?

BigQuery

Relevant log output

N/A

Code of Conduct

  • I agree to follow this project's Code of Conduct
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Incorrect behavior inside of ibis
Projects
Archived in project
Development

Successfully merging a pull request may close this issue.

1 participant