sql时间比较查询当前时间的数据，前一条，后一条

最新推荐文章于 2024-07-03 13:47:39 发布

iteye_13003

最新推荐文章于 2024-07-03 13:47:39 发布

阅读量784

点赞数

文章标签： SQL ITeye

本文链接：https://blog.csdn.net/iteye_13003/article/details/82061905

版权


select top 1 * from CheckBill where datediff(second,'2011-05-05 15:56:00',checkDate) > 0 order by CheckDate asc

select top 1 * from CheckBill where datediff(second,checkDate,'2011-05-05 15:56:00') > 0 order by CheckDate desc

select top 1 * from CheckBill where convert(varchar(19),checkDate,120) = '2011-05-05 15:56:00' order by CheckDate desc

select top 3 * from CheckBill order by CheckDate desc

[img]http://dl.iteye.com/upload/attachment/476081/5b76ab08-9d61-3933-be2a-2c649cdbe883.jpg[/img]