change date julian to gregorian date
hello,
i have a date julian: 9153, where firs digit represent year, and other three digit represent the day, the questio is how i to convert this four digits a gregorian date.
thank for your help.
<font size="2"><span style="color: blue">select </span>trunc<b><span style="color: maroon">(</span></b>to_date<b><span style="color: maroon">(</span></b>substr<b><span style="color: maroon">(</span></b><span style="color: red">'0365'</span><b><span style="color: maroon">, </span></b><span style="color: olive">1</span><b><span style="color: maroon">, </span></b><span style="color: olive">1</span><b><span style="color: maroon">), </span></b><span style="color: red">'RR'</span><b><span style="color: maroon">), </span></b><span style="color: red">'RR'</span><b><span style="color: maroon">) + </span></b>substr<b><span style="color: maroon">(</span></b><span style="color: red">'0365'</span><b><span style="color: maroon">, </span></b><span style="color: olive">2</span><b><span style="color: maroon">, </span></b><span style="color: olive">3</span><b><span style="color: maroon">) - </span></b><span style="color: olive">1 </span><span style="color: blue">from </span>dual</font>
0