Hi, I have below query where i pull data based on the Iso week number.
My problem is that a week starts on Monday till Sunday when i would like to pull from Sunday till Saturday.
How can i update my below query to do so?
Thanks for your help
SELECT User, crtd_dtt
WHERE (to_number(to_char( updt_dtt, 'iW')) = '16' and to_char(crtd_dtt, 'YYYY') = to_char(sysdate, 'YYYY')
order by User ;
Below 2 first columns are the values and formats i can have in the table