sql datetime field aggregation

[Kojo]

Is there a way in Solr SQL to truncate data and aggregate it? for
example, by month or year in a datetime field? Or is the Solr approach
to create separate fields to enable these aggregations?

Thanks in advance,
Koji