SQL 日期轉微秒
SQL
SELECT
cast(datediff(s, '1970-01-01', '2020-03-03') AS difSeconds)*1000 AS difMilliSeconds
/*
s => 秒
s*1000 => 微秒
*/
DATEDIFF是算兩個日期間的間隔,傳回帶正負號的整數
DATEDIFF ( datepart , startdate , enddate )
https://dotblogs.com.tw/lastsecret/2010/10/04/18097