Oracle SQL: selecting date field without day (Only Month and Year)

Question

I need to select values from a Database where I have a complete Date. Now I have to get this Date without the Day because I have to group and count them per Month.

I did it like this, but this will get me the Month like for January with 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 for this:

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