What is the date function used to display month name from Date column in Teradata
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'