oracle sql format date code example

Example 1: sql to char function with date

SELECT
  TO_CHAR( sysdate, 'YYYY-MM-DD' )
FROM
  dual;

Example 2: specific date format oracle

TO_CHAR (TO_DATE('0297','MM/YY'), 'MM/YY')

Example 3: date format in oracle

e.g., 01-JAN-17