[Enhancement](good-first-issue) Support some date functions

[zclllyybb]

Search before asking

• I had searched in the issues 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

• I agree to follow this project's Code of Conduct

[cat-with-cat]

I want to try it, please assign it to me.

[cutiepie-10]

May I help in this issue @cat-with-cat ?
I am new and want to contribute something on this issue

[HashHaran]

Hey @cat-with-cat @zclllyybb @zhangstar333, I am interested to contribute to doris. I will start by learning more about the project and the code base. Meanwhile, @cat-with-cat if you can update on whether you have started working on the issue here. I could get started working on the issue.

[zclllyybb]

hi @cutiepie-10 and @HashHaran . As I know @cat-with-cat is working on this issue. I released a new one here. If you interested in it, feel free to pick it.

[riya9142]

hey @cat-with-cat and @zclllyybb , in case you need any help please let me know . I am eager to contribute to this issue.

[zclllyybb]

hey @cat-with-cat and @zclllyybb , in case you need any help please let me know . I am eager to contribute to this issue.

hey @cat-with-cat could you share your advance and planning here?

[cat-with-cat]

hey @cat-with-cat and @zclllyybb , in case you need any help please let me know . I am eager to contribute to this issue.

hey @riya9142 and @zclllyybb , I have completed the coding of the logic and am now conducting tests. Thanks

[zclllyybb]

hey @cat-with-cat and @zclllyybb , in case you need any help please let me know . I am eager to contribute to this issue.

hey @riya9142 and @zclllyybb , I have completed the coding of the logic and am now conducting tests. Thanks

great. so @riya9142 if you are interested in contributing in Doris, maybe you can look https://github.com/orgs/apache/projects/424? It's a great project which has many subtasks.