Oracle SQL: selecting a date field without a day (month and year only)

Question

I need to select values ​​from a database where I have the full date. Now I have to get this date without a day, because I have to group and count them per month.

I did it this way, but it will give me a month, like in January, from 1, and I need 01 ...

(extract(YEAR,Month from ak.date ) || '.' ||extract(Month from ak.date) ) as Datum 

Answer 1

Use the TO_CHAR function to do this:

 TO_CHAR(ak.date, 'YYYY.MM') as Datum 

Answer 2

Another way:

 TRUNC(ak.date, 'MM') 

The advantage of this is that sorting by date and arithmetic by date continue to work.