Question

mysql 查询条件在当年一月一日到当前日期的记录 sql语句怎么写？

Answer 1

mysql> select MAKEDATE(YEAR(NOW()), 1) ;
+--------------------------+
| MAKEDATE(YEAR(NOW()), 1) |
+--------------------------+
| 2013-01-01               |
+--------------------------+
1 row in set (0.00 sec)

这个效果？

Answer 2

select * from A where A.date > 'yyyy-mm-dd' and A.date < curdate();

追问

怎么取到当年的1月1日啊？

追答

select * from A where A.date< curdate() and year(A.date)=year(curdate()) ;