Re: Format Number to Date

Thank you for your response and I will explain how the Date is in Oracle :

In ASP, I have the date with this format : 24/01/72. To put the date in the field (NUMBER(6)), I do this operation : CLNG(24/01/72)
When I want to write the date in ASP, I do : CDATE(26789)

But, I want to do a request which group by month or by date, like :

SELECT TO_DATE('24/01/03','MM') FROM MyTable

My date is in the number format, so I should transformate 26789 in date format. I think that the request must be like :

SELECT TO_DATE(TO_DATE(TO_CHAR(2678),'DD/MM/YY'),'MM') FROM MyTable Received on Tue Feb 04 2003 - 01:46:16 CST