Getting distinct years in Rails and Postgresql

gistfile1.rb

# start_time is a #datetime column, Postgres stores as a timestamp, we need to use date_part to extract 'year'

Event.select("date_part('year', start_time)").uniq

# Spits out
# SELECT DISTINCT date_part('year', start_time) FROM "events"