[CALCITE-6449] Enable PostgreSQL implementations of to_date/to_timestamp

[normanj-bitquill]

• Supports all date/time format patterns of PostreSQL 14
• Oracle will use the existing implementations

[mihaibudiu]

@normanj-bitquill I find it very convenient to first run ./gradlew build on my local machine before submitting a commit. This catches most of the problems, and is faster than the CI.

[normanj-bitquill]

@normanj-bitquill I find it very convenient to first run ./gradlew build on my local machine before submitting a commit. This catches most of the problems, and is faster than the CI.

I run that. The errors here are when it is run with the -PenableCheckerframework flag. I am running that locally now.

[mihaibudiu]

the checkerframework is still not happy Please leave a note when this is ready for review

[normanj-bitquill]

@mihaibudiu Looks like I have resolved the checkerframework issues. Can you take another look?

Thank you for all of the help.

[normanj-bitquill]

Will you also add one of these nice .iq scripts that has been compared with Postgres?

@mihaibudiu I have added many tests for to_date and to_timestamp to the postgresql.iq file.

[mihaibudiu]

I think that you can squash the commits. I don't know if you want more than 1 - up to you.

[sonarqubecloud[bot]]

Quality Gate passed

Issues
17 New issues
0 Accepted issues

Measures
0 Security Hotspots
79.1% Coverage on New Code
2.5% Duplication on New Code

See analysis details on SonarCloud

[normanj-bitquill]

The commits have been squashed.