[Feature] Refactor date/datetime type

[Gabriel39]

Search before asking

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

Description

Currently, some problems still exist in Doris date/datetime type.

1. We have different formats for date/datetime type in storage layer and execution layer and we have to do this transformation to read/write from/to storage.
2. We only support precision to second now. We need to support micro-seconds in the future
3. Timezone is not supported now which is needed for users.

I will do this job in following steps:

1. Add new data type DateV2/DatetimeV2/TimeV2 in FE.
2. Use new format in execution layer in order to more effecient computation.
3. Add new data type DateV2/DatetimeV2 and unify storage layer and execution layer.
4. Support Timestamp.
5. Support timezone for DatetimeV2 and Timestamp.

Use case

No response

Related issues

No response

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