Months are displayed in alphabetical order, what should I do?

Question

Oracle

My report is generated with a query that looks like this: SELECT count(INDENTURE.ID_INDENTURE) as kolvo, TYPE_PROPERTY.TYPE_PROPERTY as type,
TO_CHAR(TRUNC(INDENTURE.DATA_IN,'MM'), 'FMMonth') as datas from TYPE_PROPERTY INNER JOIN (INDENTURE INNER JOIN PROPERTY ON INDENTURE.ID_PROPERTY = PROPERTY.ID_PROPERTY) ON TYPE_PROPERTY.ID_TYPE_PROPERTY = PROPERTY.ID_TYPE
WHERE INDENTURE.DATA_IN BETWEEN :P22_START AND :P22_FINISH
HAVING COUNT(INDENTURE.ID_INDENTURE) >= 1 GROUP
.
(month from TRUNC(INDENTURE.DATA_IN,'MM')),
TO_CHAR(TRUNC(INDENTURE.DATA_IN,'MM'), 'FMMonth')
order by EXTRACT(month from TRUNC(INDENTURE.DATA_IN,'MM')) ;

seriesname:
value: kolvo
This is how scary everything is displayed:

Answer 1

so you can also store the months in the database as names? :)
for all dates and operations with them, the easiest way is to use a timestamp, which is converted to "human" dates only to be shown on the page at the very last moment