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.

Reply via email to