SELECT * FROM 文章表名WHERE day(发布时间字段)=day(getdate())
SELECT * FROM tb WHRER left(datetime,10)='2008-10-24'tb是表名，datetime是字段名
