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

2024-04-01 03:09:19

使用函数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() as sumhours
from
            daywork
where
            userid='myid'
            and date_format(date,'%Y')=Year(CurDate())
group by    weekyear
order by    weekyear

最新文章

热门文章