[GitHub] [doris] WinkerDu opened a new issue, #16967: [Enhancement] Support function `microseconds_add` for datetimev2

[via GitHub]

WinkerDu opened a new issue, #16967:
URL: https://github.com/apache/doris/issues/16967

   ### 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
   
   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");`
   
   <img width="1499" alt="image" 
src="https://user-images.githubusercontent.com/11454734/220237107-c5a279ff-88b8-48c9-bd61-1308a04a3f61.png";>
   
   
   ### Solution
   
   1. Introduce new TimeUnit `MICROSECONDS` to `vdatetime_value`
   2. `date_add_interval` computation should handle `MICROSECONDS` unit
   
   ### Are you willing to submit PR?
   
   - [X] 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