时间戳

首页 > 解决方案 > 使用 datediff 删除毫秒

sql - 使用 datediff 删除毫秒

问题描述

查询返回我要删除的毫秒数

SELECT FOLIO_NUMBER, TERMINAL_NAME, ORDER_ENTRY_TIME, START_LOAD_TIME, END_LOAD_TIME,
       datediff(mi, ORDER_ENTRY_TIME, START_LOAD_TIME) AS STAGING_MINUTES,
       datediff(mi, START_LOAD_TIME, END_LOAD_TIME) AS LOADING_MINUTES,
       datediff(mi, ORDER_ENTRY_TIME, END_LOAD_TIME) AS TERMINAL_MINUTES   
FROM ORDERS  
JOIN TERMINAL_OWNER ON ORDERS.LOADING_TERMINAL_ID = TERMINAL_OWNER.TERMINAL_ID
WHERE TERMINAL_ID = '1913' AND FOLIO_NUMBER >= '20190101' AND FOLIO_NUMBER <= '20190201'
ORDER BY FOLIO_NUMBER ASC

标签： sqldatediffmilliseconds

解决方案

推荐阅读