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

gtxyzz 数据库 2023-02-25 774浏览 0

使用函数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