EXTRACT_DATE was only ever an internal operator, so you should not have been calling it from SQL. It was removed in https://github.com/apache/calcite/commit/796a28f9a. If you read through the test changes in that commit you will see that it can be replaced by EXTRACT. IIRC, it returns a value in milliseconds since epoch, so if you want days since epoch you will need to divide the value by 86,400,000.
> On Nov 10, 2018, at 8:01 PM, Lijun Cao <[email protected]> wrote: > > Hi all, > > I upgraded Calcite from 1.13 to 1.16 recently, and then I have found that > SqlstdOperatorTable.EXTRACT_DATE had been removed which caused my source code > doesn’t work. > > Are there any alternative scheme to solve it ? > > Really grateful if someone can help me. > > Best Regards > > Lijun Cao >
