How to get all years of records in Laravel table?

Question

Laravel

There is a table of posts with a standard field created_at.
You need to get a list of all post publication years.
What is the best way to do this?

Answer 1

$query->select(DB::raw( 'YEAR(created_at) as year' ))->distinct()

Answer 2

$query->groupBy(DB::raw('YEAR(created_at)'))