SELECT LOG_ID, LOG_NAME, SURGERY_DATE

FROM OPENQUERY(CLARITY, 'SELECT * FROM OR_LOG WHERE SURGERY_DATE >= trunc(sysdate-1) and SURGERY_DATE <trunc(sysdate)')

Please do not use where trunc(surgery_date)=trunc(sysdate-1) unless you have a functional-index on SURGERY_DATE.

The query above will use a normal index on SURGERY_DATE if present, stats are up to date and the datadistribution is favourable.