SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get yesterday's date

637632Oct 1 2008 — edited Oct 1 2008

Hi,

I use TO_CHAR(SYSDATE,'YYYYMMDD') - 1 to get yesterday's date.
But this logic seems to fail when run on the 1st day of the month (ex: 20081001).

How can I get yesterday's date?

Thanks,
Raja

This post has been answered by SomeoneElse on Oct 1 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2008

Added on Oct 1 2008

6 comments

4,945 views