how to convert date from yyyy-mm-dd to mm/dd/yyyy in oracle?
If you want to give a date a specific format then you will need to convert it to a string: SELECT TO_CHAR( DATE '2016-05-01', 'MM/DD/YYYY HH24:MI:SS' ) FROM DUAL; Why your query does not work: TO_DATE( value, frmt ) expects a string value and a format mask.