zclllyybb opened a new issue, #44932: URL: https://github.com/apache/doris/issues/44932
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description We need to implement function `NEXT_DAY` and `PREVIOUS_DAY`, for the next day/previous day of input argument(which accept `datev2` or `datetimev2` type) and for `LAST_DAY ` we support the second argument(optinal, if not provided, act like got `month` so that the old behaviours won't be change) to get the last day of current week/month/day/quarter... and so on ### Solution To support a function, we need: function implementation and registration in BE function signature and visitor for nereids planner in FE the constant fold implementation in FE, behave just same with it in BE, like `functions/executable/NumericArithmetic.java` in https://github.com/apache/doris/pull/40744/files another function docs pr in https://github.com/apache/doris-website you can reference pr like https://github.com/apache/doris/pull/33005/files and ATTN! we must have enough testcases, like what https://github.com/apache/doris/pull/40462/files did. ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org