Does STR_TO_DATE appear among the supported functions? https://calcite.apache.org/docs/reference.html
Julian > On Feb 25, 2023, at 11:19 AM, Ein <[email protected]> wrote: > > I want to enable STR_TO_DATE or TO_DATE For functions such as DATE, I set > according to the document： > Properties info=new Properties() > info.setProperty("caseSensitive", "false"); > info.setProperty("conformance", "LENIENT"); > // Connection baseConnection = > DriverManager.getConnection("jdbc:calcite:fun=postgresql", info); > //CalciteConnection connection = > baseConnection.unwrap(CalciteConnection.class); > CalciteConnection connection = > DriverManager.getConnection("jdbc:calcite:fun=postgresql", > info).unwrap(CalciteConnection.class); > However, it does not take effect, and an error will be reported: No match > found for function signature STR_ TO_ DATE(<CHARACTER>, <CHARACTER>) > How can I change or locate this error?Thanks.
