Migrate Datetime functions to `invoke_with_args`

[goldmedal]

Is your feature request related to a problem or challenge?

As #14652, invoke_batch is deprecated. We should migrate all the UDFs to invoke_with_args. This issue would focus on the function in the datafusion/functions/src/datetime.

Describe the solution you'd like

• Remove invoke_batch for the function implementation and use implement invoke_with_args instead.

Describe alternatives you've considered

No response

Additional context

No response

[haydenwoodhead]

I'd be keen to give this a go.

[goldmedal]

I'd be keen to give this a go.

Thanks @haydenwoodhead. Feel free to use take keyword to assign yourself.

[haydenwoodhead]

take

[aviral-bhardwaj]

take

[varun-bhardwaj-sde]

take

[onlyjackfrost]

take