date functions: to_month() to_year()

[Yosi Botzer]

Hi,

Assuming that I have a column (part of the key) of type date, if I want to
aggregate by month or by year are there any functions like to_month() or
to_year() that I can use?

Yosi