How to change date format in 30-06-2022 to 30-June-2022
we have developed date as of now 30-06-2022 but business wants this format 30-June-2022.
to_char(CURRENT_DATE,'DD-MM-YYYY'), -- 30-06-2022
May I know to change month into alphabetical.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):