Apache Doris 中文技术论坛
Questions Tags Users Badges

【已解决】datetimeV2如何转化成毫秒时间戳

Asked Mar 6, 2024 Modified Mar 8, 2024
Viewed 120
2.0

求助大神,datetimeV2如何转化成毫秒时间戳

edited Mar 8, 2024
Kaven5
asked Mar 6, 2024
1 Answers

看文档没有直接转为毫秒的函数,只能先 UNIX_TIMESTAMP,然后加上 extract(microsecond from cast('2022-09-22 17:01:30.000123' as datetimev2(6)));

或者加上 microsecond(cast('1999-01-02 10:11:12.000123' as datetimev2(6)))

相关函数见文档:EXTRACT,MICROSECOND,UNIX_TIMESTAMP

edited Mar 8, 2024
zhb123319
answered Mar 6, 2024
Related Questions
fe节点空指针,两个be节点只有一个存活
1 answers
求助:be频繁重启,目前推测由于arm内存管理,能否分析帮忙具体报错和提供解决措施?
doris单表分区数量限制
1 answers
【求助】升级到2.1.8版本后,从S3导入数据变慢
1 answers
EXPORT 导出cvs 数据为空 导出为\N 怎么修改这个设置
1 answers
storage policy删除以后,日志一直报could not find storage_policy
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.