Contents

Oracle 時間運算 筆記

Contents

TODO: 之後有空來整理

昨天

1
AND oh.tran_date BETWEEN TRUNC(SYSDATE - 1) AND TRUNC(SYSDATE) - 1/86400

sql - How can I select records ONLY from yesterday? - Stack Overflow