Converts a date to a formatted string.
Syntax
TO_CHAR(date, 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;
Converts a date to a formatted string.
TO_CHAR(date, fmt)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;