Date validation does not check 00 in day part.

[UndefinedSy]

Please check the FAQ documentation before raising an issue

Describe the bug (required)
the validation in date parser only checks the overflow of day.
input like DATE("2024-07-00") will not be rejected in writing, and will finally lead to a problem in reading.

Your Environments (required)

• OS: uname -a
• Compiler: g++ --version or clang++ --version
• CPU: lscpu
• Commit id (e.g. fee249b3)

How To Reproduce(required)

Steps to reproduce the behavior:

1. write a date type data like DATE("2024-07-00")

Expected behavior
this invalid date should be rejected in the parser.

Additional context