In this blog we are going to see how to fetch the name of the Month in Words using SQL To fetch the name of the month (ex: January) , use below sample SQL as reference Query: select to_char(sysdate,'dd- mon -yyyy', 'nls_date_language = english') curr_date from dual Result: CURR_DATE 30- jan -2019 Query: select to_char(sysdate,'dd- Mon -yyyy', 'nls_date_language = english') curr_date from dual Result: CURR_DATE 30- Jan -2019 Query: select to_char(sysdate,'dd- MON -yyyy', 'nls_date_language = english') curr_date from dual Result: CURR_DATE 30- JAN -2019 Query: select to_char(sysdate,'dd- Month -yyyy', 'nls_date_language = english') curr_date from dual Result: CURR_DATE 30- January -2019 Query: select to_char(sysdate,'dd- MONTH -yyyy', 'nls_date_language = english') curr_date from dual Result: CURR_DATE 30- JANU