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

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

Asked Mar 6, 2024 Modified Mar 8, 2024
Viewed 102
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
2.0.2版本同步物化视图不生效
flink-doris-connector的25.1.0版本使用CdcMysqlSyncDatabaseCase当任务启动后MySQL后新增的表无法同步,还需要其它什么设置
1 answers
Doris实现动态行转列
1 answers
使用聚合模型聚合小时数据,出现前后结果不一致该如何排查
1 answers
扩容BE后,如何将使用多年的表的副本数调整为3个
1 answers
doris2.0.3 mow表数据莫名奇妙的减少了
2 answers

Terms of service Privacy policy

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