我想你想要:
select emp_fn_name, emp_fn_name
from employees e
where not exists (select 1
from schedule s
where s.emp_id = e.id and
s.start < ‘03:00PM’::time and
s.end > ‘02:00PM’::time
);
</code>
我有员工表,我试图只查询时间戳范围内的员工。
选择
emp_fn_name,emp_fn_name,
TO_TIMESTAMP(e.start_time,‘HH12:MIAM,PM’)::时间,
…