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

Viewed 79

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

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)))

相关函数见文档:EXTRACTMICROSECONDUNIX_TIMESTAMP