Conversion Functions

  • TO_CHAR(date/number, format) – convert to string
  • TO_DATE(string, format) – convert to date
  • TO_NUMBER(string) – convert to number
SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY'), TO_DATE('2024-01-01', 'YYYY-MM-DD'), TO_NUMBER('12345') FROM dual;