OracleString FunctionsTO_CHAR
TRANSLATE

TO_CHARString Functions

REGEXP_REPLACE

Converts a value to a string.

Syntax

TO_CHAR(expr [, fmt])

Example

Enter values below to update the example in real time.

hire_date
hire_date_kr
employees
SELECT TO_CHAR(hire_date, 'YYYY"년" MM"월" DD"일"') AS hire_date_kr
FROM employees;