计算PostgreSQL中两个日期之间的工作时间

SELECT EXTRACT(EPOCH FROM (date2 - date1)) AS seconds_between;

SELECT 
    COUNT(*) FILTER (WHERE EXTRACT(DOW FROM d) NOT IN (0,1)) * 8 * 3600 + 
    COUNT(*) FILTER (WHERE EXTRACT(DOW FROM d) IN (2,3,4,5)) * 1800
FROM generate_series(date1, date2, INTERVAL '1 day') d
WHERE d >= date1 AND d <= date2;