Even though the business requirement states the input as a "julian" date, it is actually a 3 digit number being passed to the Oracle stored procedure. For example, if the input is '001' then I need to convert it to January1 of the current year or if it is 010 convert it to January 10 of the current year etc. How would i do that taking into consideration leap years too?
Please suggest. Thank you for your time.