week to date
Dear All,
It is no problem to convert a date to get the week number:
TO_CHAR(sysdate, 'YYYYIW')
But what I need to do is to go the other way and generate the date of the Monday for that particular week.
With a month and the TO_DATE command this would be no problem. And from my googling I see that there are procedures available that will do what I need.
But my question is whether I am able to do this conversion with an in-built Oracle function? Or do I need to incorporate PL/SQL?
Any tips would be gratefully received.
Regards and thanks,
Alan