查询离某个时间最近的记录

select top 1 * from table where order by abs(datediff(d,日期列,'2008-12-20')) asc