Hi,
I have a table from which I extract the months with a group by statement :
SELECT
EXTRACT(MONTH FROM "DATE_FIN_PÉRIODE") AS month,
SUM (CONSOMMATION)
from FL_SIGEIF
group by EXTRACT(MONTH FROM "DATE_FIN_PÉRIODE")
order by 1;
It gives me something like that :
The months are in number format. How to get their names instead ? For example 1 would be replaced by January, etc...
Best regards.