SQL语句里怎么获得当前年份（MySQL数据库）

使用函数Year及CurDate的组合： Year(CurDate())

select      date_format(min(date),'%Y-%m-%d') as mindate,
            date_format(max(date),'%Y-%m-%d') as maxdate,
            weekofyear(date) as weekyear,
            format(sum(hours),2) as sumhours 
from 
            daywork 
where 
            userid='myid' 
            and date_format(date,'%Y')=Year(CurDate()) 
group by    weekyear 
order by    weekyear

 

转载于:https://www.cnblogs.com/xiandedanteng/p/5681305.html