What is the date function used to display month name from Date column in Teradata I have a table with Date column and I need to display Month name.

I found EXTRACT(MONTH) function in teradata to display the month_number but it does not serve my purpose. I can still use case statement on month_number to display the month name.

Can someone help me with a better approach?
The full name is returned by to_char(dateCol, 'Month')

'Month' -&gt; 'October'
'MONTH' -&gt; 'OCTOBER'
'month' -&gt; 'october'
'Mon' -&gt; 'Oct'
'MON' -&gt; 'OCT'
'mon' -&gt; 'oct'