Unable to convert date in specific format

Summary:

We are fetching termination date from xml table which is fetched in string format. We need to convert date in format 'DD-MON-YYYY' which is not happening. Data is getting fetched as 'dd-mm-yyyy'

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

24B

Code Snippet (add any code snippets that support your topic, if applicable):

SQL query for reference :-

SELECT
papf.person_number AS employee_number,
ppnf.first_name
|| ' '
|| ppnf.last_name AS employee_name,
TO_CHAR(TO_DATE((
SELECT
(ntd.actual_termination_date)
FROM
XMLTABLE('$A/PeriodOfServiceEORow'