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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,127 views