Format Number to Date

Hello,

The date are in field NUMBER(6), example : 24/01/72 = 26322 The problem is in this requete :

SELECT TO_DATE(V.date_debut, 'MM') FROM ***

The date in number must be in format date but the function TO_DATE isn't correct.

Do you have a solution ?

Thank you Received on Mon Jan 27 2003 - 09:58:53 CST