hi
I have a table with a date column set as decimal type, another thing is that they have have entered an extra 1 in front of each value due to the Y2K problem, example for 2010 jan it shows 11001 is there any way for me to convert this so that the data shows as either 2010 Jan or as jan-10 or as 01-10 either one of this would good.

thank you

bhavya