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

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

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

trunc tran date    trunc sysdate -1

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

[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