select EXTRACT(YEAR FROM (timestamp with time zone 'epoch' + dato * interval '1 second')) as bar_year from bar_dag where bar_year=2008 order by dato desc;