I was able to retrieve the size per year through a similar query
Code: Select all
select extract(year from create_time) YEAR ,SUM((length(content)/1024/1024)) SIZEINMB FROM article_attachment GROUP BY extract(year from create_time);
Manoj.
Code: Select all
select extract(year from create_time) YEAR ,SUM((length(content)/1024/1024)) SIZEINMB FROM article_attachment GROUP BY extract(year from create_time);