Conversion Functions

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;