I have a 3rd party OCR software that can only export a date in a YYYY0DOY format. The 0 just separates the 4 digit year (YYYY) from the number of days into the year (DOY). So, for example it puts today's date which is July 21, 2008 as 20080203. Its the 203rd day of 2008. Is there an easy way to convert the 203 into July 21 so that I can combine that with the year to export into a valid date column in Oracle 9i?
