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

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

sql oracle plsql

Another way:

TRUNC(ak.date, 'MM')

Advantage of this is that date sorting and date arithmetic still work.

CodeHunter