How can I select records ONLY from yesterday

Question

I ve spent hours searching the web for an answer to this question     Here s what I currently have   select    from    order header oh where   tran date   sysdate-1

User · Answer

If you want the timestamp for yesterday try something like    CURRENT TIMESTAMP - INTERVAL  1  DAY

User · Answer

If you don t support future dated transactions then something like this might work   AND oh tran date  gt   trunc sysdate-1

User · Answer

This comment is for readers who have found this entry but are using mysql instead of oracle  on mysql you can do the following  Today  SELECT     FROM  WHERE date tran date    CURRENT DATE     Yesterday  SELECT     FROM yourtable  WHERE date tran date    DATE SUB CURRENT DATE    INTERVAL 1 DAY

User · Answer

to char tran date   yyyy-mm-dd     to char sysdate-1   yyyy-mm-dd

User · Answer

Use   AND oh tran date BETWEEN TRUNC SYSDATE - 1  AND TRUNC SYSDATE  - 1 86400   Reference  TRUNC  Calling a function on the tran date means the optimizer won t be able to use an index  assuming one exists  associated with it   Some databases  such as Oracle  support function based indexes which allow for performing functions on the data to minimize impact in such situations  but IME DBAs won t allow these   And I agree - they aren t really necessary in this instance

User · Answer

trunc tran date    trunc sysdate -1

[sql] How can I select records ONLY from yesterday?

Examples related to sql

Examples related to database

Examples related to oracle

Examples related to plsql