Question: how to convert dd-mm-yy to dd-mm-yyyy in oracle?
Answer: 3 Answers. For a simple test, try this: select to_char(sysdate,'DD/MM/YYYY') "Converted" from dual; You can replace "sysdate" in that query with a date column in your database (if you also change "dual" then to the table name for that column).