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

Dec 15, 2021 support for parseDateTimeBestEffort function #46816

Closed
UnamedRus opened this issue Feb 24, 2023 · 0 comments · Fixed by #47071
Closed

Dec 15, 2021 support for parseDateTimeBestEffort function #46816

UnamedRus opened this issue Feb 24, 2023 · 0 comments · Fixed by #47071
Labels
easy task Good for first contributors feature help wanted

Comments

@UnamedRus
Copy link
Contributor

Use case

SELECT parseDateTimeBestEffort('Dec 15, 2021')

Query id: b849327e-3893-4a97-9a6a-da59b61f4a7a


0 rows in set. Elapsed: 0.002 sec.

Received exception from server (version 22.13.1):
Code: 6. DB::Exception: Received from localhost:9000. DB::Exception: Cannot parse string 'Dec 15, 2021' as DateTime: syntax error at position 6 (parsed just 'Dec 15'): While processing parseDateTimeBestEffort('Dec 15, 2021'). (CANNOT_PARSE_TEXT)

SELECT parseDateTimeBestEffort('Dec 15 2021')

Query id: 988b6d95-d22c-4882-a835-07dc8261a7bb

┌─parseDateTimeBestEffort('Dec 15 2021')─┐
│                    2021-12-15 00:00:00 │
└────────────────────────────────────────┘

1 row in set. Elapsed: 0.001 sec.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
easy task Good for first contributors feature help wanted
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants