Does anyone know of a way to change a SQL View of JDE data to translate their date in to a normal date format i.e.  09/05/01.  The JDE "date" format isn't stored in SQL as a date, but as a numeric field, 9 digits

JDE Format:

CYYddd  

C - Century
YY - YY  
Ddd - day of year

So:
Century - 0 = 1900
Century  - 1 = 2000
YY = 01, 02, 67, 95, etc.
DDD = 1-365 to represent  the day.  
 

We are trying to find the best way to convert it in order to pull it into Cognos Impromptu.