Chapulin
Active Member
Hi. I'm building some queries in PL SQL to the JDE OneWorld database and I found out that Date fields are saved in the DB as decimal numbers!! How can I convert them to really Oracle Dates so I can include them in my SQL statements like every other fields? I've already tried every to_char and to_date conversion that came up to my mind!! thanks a lot!