Finding day of the week in oracle

Question

to_char(sysdate,'Day') returns the current day of the week. What I want is to get the date of the most recent "sunday" that passed. Of course we can go for a complex query to get it done. But is there any simple way I'm not aware of?

Answer 1

You can do it with

SELECT NEXT_DAY(SYSDATE-8, 'SUN') FROM DUAL;

here

SYSDATE-8

returns the day before 8 days &

NEXT_DAY(mydate, 'SUN') 

returns the next sunday to it