Question: how to change date format from mm/dd/yyyy to dd/mm/yyyy in oracle?
Answer: If your existing data is in MM/DD/YYYY format, then you want: select to_date(date_column,'MM/DD/YYYY') from table; to convert the existing data to DATE values.