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)
*/
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)
*/