【sql】之查询昨天的记录

 

SELECT * FROM community_play a WHERE TO_DAYS(NOW( )) - TO_DAYS( a.CREATE_DATE_TIME) = 1  

 

http://blog.csdn.net/cangchen/article/details/44978531