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!

calculate date of nth day of a particular year

3574931Jan 2 2018 — edited Jan 2 2018

I have a text column containing a string the consists of a year (1st 4-chars), followed by the day of the year, 329 in this example. I am looking for some assistance with a query to calculate the date for the given day of the year (329), for the year (2017).

2017329

Thanks in advance.

This post has been answered by Frank Kulash on Jan 2 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 30 2018

Added on Jan 2 2018

7 comments

873 views