You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Gabriel39 (via GitHub)" <gi...@apache.org> on 2023/02/09 08:29:53 UTC
[GitHub] [doris] Gabriel39 opened a new issue, #16560: [Enhancement] Support microseconds in function `unix_timestamp`
Gabriel39 opened a new issue, #16560:
URL: https://github.com/apache/doris/issues/16560
### 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
Now Doris already supports DATETIMEV2 which could have precision up to microseconds. But function `unix_timestamp` still can not process those microseconds. So we need this feature for users who need timestamp with microseconds.
In Doris:
`CREATE TABLE `datetime_table` (`date` datetime(3) NOT NULL COMMENT '数据灌入日期时间' ) distributed by hash(`date`) buckets 1 properties("replication_num"="1");`
`insert into `datetime_table` values ("2022-01-01 10:10:10.111");`
`select unix_timestamp(`date`) from datetime_table;`

In MySQL:
`CREATE TABLE `datetime_table` (`date` datetime(3) NOT NULL COMMENT '数据灌入日期时间' );`
`insert into `datetime_table` values ("2022-01-01 10:10:10.111");`
`select unix_timestamp(`date`) from datetime_table;`

### Solution
_No response_
### Are you willing to submit PR?
- [ ] 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-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] liangjiawei1110 commented on issue #16560: [Enhancement] Support microseconds in function `unix_timestamp`
Posted by "liangjiawei1110 (via GitHub)" <gi...@apache.org>.
liangjiawei1110 commented on issue #16560:
URL: https://github.com/apache/doris/issues/16560#issuecomment-1560609901
I'd like to try it.
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Enhancement] Support microseconds in function `unix_timestamp` [doris]
Posted by "Gabriel39 (via GitHub)" <gi...@apache.org>.
Gabriel39 closed issue #16560: [Enhancement] Support microseconds in function `unix_timestamp`
URL: https://github.com/apache/doris/issues/16560
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Enhancement] Support microseconds in function `unix_timestamp` [doris]
Posted by "hongkun-Shao (via GitHub)" <gi...@apache.org>.
hongkun-Shao commented on issue #16560:
URL: https://github.com/apache/doris/issues/16560#issuecomment-1817734261
May I ask if anyone else is dealing with this issue? If not, could you assign it to me to try? However, since I am new to the community, I cannot guarantee that I can complete it, but I will do my best. @Gabriel39
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] BBB-source commented on issue #16560: [Enhancement] Support microseconds in function `unix_timestamp`
Posted by "BBB-source (via GitHub)" <gi...@apache.org>.
BBB-source commented on issue #16560:
URL: https://github.com/apache/doris/issues/16560#issuecomment-1449578153
I will work on it.
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Enhancement] Support microseconds in function `unix_timestamp` [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on issue #16560:
URL: https://github.com/apache/doris/issues/16560#issuecomment-1817785731
Sorry but this issue is duplicated by https://github.com/apache/doris/issues/24382. will close this. @liangjiawei1110 @hongkun-Shao
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] isHuangXin commented on issue #16560: [Enhancement] Support microseconds in function `unix_timestamp`
Posted by "isHuangXin (via GitHub)" <gi...@apache.org>.
isHuangXin commented on issue #16560:
URL: https://github.com/apache/doris/issues/16560#issuecomment-1430989813
Plz, assign it to me.
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] Gabriel39 commented on issue #16560: [Enhancement] Support microseconds in function `unix_timestamp`
Posted by "Gabriel39 (via GitHub)" <gi...@apache.org>.
Gabriel39 commented on issue #16560:
URL: https://github.com/apache/doris/issues/16560#issuecomment-1560657430
> I'd like to try it.
Great! I will re-assign this issue to you
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org