suibianwanwan, Supported in what way? When using the MySQL dialect, Calcite will generate those functions where appropriate. However, I don't believe that the parser supports these. Calcite does also support TO_TIMESTAMP. It would help if you gave us a better idea of what you're trying to accomplish using Calcite.
-- Michael Mior mm...@apache.org On Thu, Aug 15, 2024 at 10:34 AM suibianwanwan33 < suibianwanwa...@foxmail.com> wrote: > I found that Mysql's STR_TO_DATE & DATE_FORMAT functions are not > supported in Calcite, I tried to understand and contribute this. > But I'm not too familiar with this part. I've found that there are some > functions that are defined as calcite default functions in StdOperator, > some that have SqlKind, and some that are defined as OtherFunction. Of > course, there are also a lot of functions that are not supported. I would > like to know how we can distinguish these behaviors. > For example, what kind of functions should we define as calcite default > functions, I observed that calcite doesn't have a function like > to_timestamp, is this missing in the calcite standard?. And what functions > should we add to calcite? > Also, I'm wondering if this contribution is meaningful to calcite. > > > Thanks for all the replies > > > > Thanks, > suibianwanwan