--相差小时数
SELECT EXTRACT(epoch FROM (CURRENT_TIMESTAMP - TS_LRDATE)) / 60 AS minutes_diff FROM TS_FLOW_PATH_COM where TS_MK_PID ='FLOW000020230906115936389391871016964325'
TS_LRDATE 为指定时间字段
TS_FLOW_PATH_COM 表
TS_MK_PID 主键
--相差小时数
SELECT EXTRACT(epoch FROM (CURRENT_TIMESTAMP - TS_LRDATE)) / 60 AS minutes_diff FROM TS_FLOW_PATH_COM where TS_MK_PID ='FLOW000020230906115936389391871016964325'
TS_LRDATE 为指定时间字段
TS_FLOW_PATH_COM 表
TS_MK_PID 主键