减去两个时间戳将返回一个间隔。所以你想要类似的东西
SELECt (actionEndTime - actionStartTime) actionDuration FROM ActionTable WHERe actionEndTime - actionStartTime > interval '1' hour

减去两个时间戳将返回一个间隔。所以你想要类似的东西
SELECt (actionEndTime - actionStartTime) actionDuration FROM ActionTable WHERe actionEndTime - actionStartTime > interval '1' hour