[Enhancement] Support function `microseconds_add` for datetimev2

[WinkerDu]

Search before asking

• I had searched in the issues and found no similar issues.

Description

As descriptions in #16561
Now Doris already supports DATETIMEV2 which could have precision up to microseconds. But function microseconds_add is not supported yet

CREATE TABLE datetime_table (date datetime(3) NOT NULL COMMENT '数据灌入日期时间' ) distributed by hash(date) buckets 1 properties("replication_num"="1");

Solution

1. Introduce new TimeUnit MICROSECONDS to vdatetime_value
2. date_add_interval computation should handle MICROSECONDS unit

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