获取离当前时间最近的一条数据
发布时间：2020-12-12 13:00:41 所属栏目：MsSql教程 来源：网络整理
导读：?CREATE?TABLE?#testTable(id?INT,addTime?DATETIME) INSERT?INTO?#testTable SELECT?1,'2015-7-8??12:00:00'?UNION?ALL SELECT?3,'2015-04-23??10:00:00'?UNION?ALL SELECT?4,'2015-04-24?12:00:00'?UNION?ALL SELECT?5,'2015-04-24?16:00:00' SELECT?*?FRO
|
?CREATE?TABLE?#testTable(id?INT,addTime?DATETIME)
INSERT?INTO?#testTable SELECT?1,'2015-7-8??12:00:00'?UNION?ALL SELECT?3,'2015-04-23??10:00:00'?UNION?ALL SELECT?4,'2015-04-24?12:00:00'?UNION?ALL SELECT?5,'2015-04-24?16:00:00' SELECT?*?FROM?#testTable SELECT?TOP?1?*?FROM?#testTable?ORDER?BY?ABS(CAST((addTime?-?GETDATE())as?FLOAT))?ASC /* 当前时间是?14:33?事实离?16:00?才是最近的。 id??????????addTime -----------?----------------------- 5???????????2015-04-24?16:00:00.000 (1?row(s)?affected) */ （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |