to_char(to_date(xdate, 'yyyymmdd'), 'iw')
The above gives me the week of the year,
Is there a way to give me that ending saturday?
lets say results of week 01, i would rather it be, instead of week 01, the first satuday of the year.
any date format would be fine