Skip to content
New issue

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

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

Already on GitHub? # to your account

Incorrect datetime value outputs in sqlite #1969

Closed
bcho opened this issue Feb 27, 2023 · 0 comments · Fixed by #1970
Closed

Incorrect datetime value outputs in sqlite #1969

bcho opened this issue Feb 27, 2023 · 0 comments · Fixed by #1970

Comments

@bcho
Copy link
Contributor

bcho commented Feb 27, 2023

For this query:

from test_table
select [date = @2022-12-31, time = @08:30, timestamp = @2020-01-01T13:19:55-0800]

current implementation emits following query for sqlite dialect:

SELECT
  DATE '2022-12-31' AS date,
  TIME '08:30' AS time,
  TIMESTAMP '2020-01-01T13:19:55-0800' AS timestamp
FROM
  test_table

However, according to sqlite's doc: https://www.sqlite.org/lang_datefunc.html , these typed field outputs are incorrect as sqlite uses function to convert string to time values.

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant