select * from documentmanager.document_info where extract(year from createtime)=extract(year from now());
参考文章:postgresql中获取年份方法
select * from documentmanager.document_info where extract(year from createtime)=extract(year from now());
参考文章:postgresql中获取年份方法