"Raymond O'Donnell" <rod@iol.ie> writes:
> to_char(extract (month from d.dates), 'FMmonth') as month_name,
> to_char(extract (day from d.dates), 'FMday') as day_name
I think you want just to_char(d.dates, 'FMmonth') and so on.
What you're invoking above is to_char(numeric) which has entirely
different format codes...
regards, tom lane