cryptography - How to group by month-year from a differently formatted date (SQL)

Question

I've tried to self-teach myself SQL but am struggling with a dashboard I want to build.

How do I manipulate or change the date which is "08/03/18 09:00" so that I can group it by month+year and not per second?

[link to what the table looks like]

my current attempt:

SELECT AVG(price) as "price", MONTH(minute) as month
FROM prices.usd
WHERE minute > now() - interval '365 days'
AND contract_address = 'x6b175474e89094c44da98b954eedeac495271d0f'
GROUP BY month

question from:https://stackoverflow.com/questions/66056926/how-to-group-by-month-year-from-a-differently-formatted-date-sql

Answer 1

Waitting for answers