Question

postgres：获取当前年份，这个SQL语句没有看懂，求大神指点

select extract (year from (now() + interval ''0 y'' ))

Answer 1

试试我这个获取当前年份，很简单的
select extract(year from sysdate) as year from dual