For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello All
Why does this SQL give a result = 01/11/2010 and not the desired 01/01/2010
SELECT TO_DATE(TO_CHAR(1900 + FLOOR(110063/1000)),'YYYY') FROM dual ; 01/11/2010
Thanks for all feedback
Steve