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

[Date] Values that overflow date boundaries are allowed #138

Open
ohaibbq opened this issue Jan 26, 2024 · 1 comment
Open

[Date] Values that overflow date boundaries are allowed #138

ohaibbq opened this issue Jan 26, 2024 · 1 comment

Comments

@ohaibbq
Copy link
Contributor

ohaibbq commented Jan 26, 2024

In this example, the months part is parsed as 99 months where BigQuery raises an error.

SELECT PARSE_DATE("%D", "99/01/24");
BigQuery Emulator
Failed to parse input string "99/01/24" "2032-03-01"
@ohaibbq
Copy link
Contributor Author

ohaibbq commented Apr 11, 2024

This has been mostly fixed in #135, but there is still no validation on calendar dates.

For example, February 29th, 2023 is able to be parsed even though it was not a leap year.

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

No branches or pull requests

1 participant