How to convert daynumber (day nr 331) to yyyymmdd in PL / SQL?

Question

If I know that the number of days is 331 during the year, how do I convert it to yyyymmdd in PL / SQL?

+3

Chris_45 May 20, '11 at 9:20

3 answers

DECLARE @datetime2 datetime2 = '2007-01-01 13:10:10.1111111'
SELECT 'day',DATEADD(day,331,@datetime2)

0

Nighil May 20, '11 at 9:28

Another option might be something like this.

select to_char(trunc(sysdate, 'YY') + 331, 'YYYYMMDD') as day from dual

0

be here now May 26 '11 at 22:20

Tony Andrews · Accepted Answer · 2011-05-20T09:25:30+0000

To convert to DATE:

to_date(331, 'DDD')

You can then format this date, if required, with TO_CHAR.