One last question for Pablo or the oracle forum regarding dates in this SQL

SELECT LOG_ID, LOG_NAME, SURGERY_DATE

FROM OPENQUERY(CLARITY, 'SELECT * FROM OR_LOG WHERE SURGERY_DATE = TO_DATE(''08/01/2012'', ''mm/dd/yyyy'')') AS a

What is the proper expression to select yesterdays records rather than august first?

Is it WHERE SURGERY_DATE = TO_DATE((CURRENT_DATE, ''mm/dd/yyyy'')-1)

many thanks ahead of time

Phunhog