Skip to Main Content
Forums

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 friday from sysdate?

syed haiderJan 9 2019 — edited Jan 10 2019

I want to get the Friday's date based on whatever the sysdate is.

The week_end values are the Friday's dates. My report will run every week and I want o generate a query to obtain pervious Friday.

Below is the sample query I have. Currently, my sysdate is Monday and I'm hard coding it to go back two days, but sysdate can change. How can I make it dynamic to go back to last Friday?

select sysdate -2 "week_end"

from dual

pastedImage_1.png

Thanks
Comments
Post Details
Added on Jan 9 2019
#oracle, #plsql, #sql
8 comments
5,537 views