写一段pgsql,计算“排班内的签入时间”和“排班内的签出时间”以秒为单位的时间差

SELECT (EXTRACT(EPOCH FROM (shift.end_time - shift.start_time))) AS time_diff
FROM shift
WHERE (NOW() >= shift.start_time) AND (NOW() <= shift.end_time)