I am trying to convert a column in a database into a timestamp format, then I want to see the number of counts for each year.
EXTRACT(YEAR FROM column_name)
GROUP BY column_name;
'I get an error message that says no function matches the given name and argument types. You might need to add explicit type casts.'
Is extract the wrong function?