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!

Find the date of monday for nth week in Oracle RDB

2835010Mar 3 2016 — edited Apr 5 2016

How to find the date of monday for nth week in Oracle RDB?

We can write query easily in 11g but it doesn't work in Oracle RDB.

e.g.

Input = 201602

where 2016 = year

02 = nth week of year 2016

I want the output as "11-JAN-16".

Thanks in advance!!!

Regards,

Kashif

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2016

Added on Mar 3 2016

3 comments

254 views