SQL最近日期 [英] SQL Nearest Date

问题描述

我需要获取一个日期(例如'2010-04-27')作为php中的字符串，并在表中找到最近的5个日期.表中的日期将另存为日期类型.

I need to get a date such as '2010-04-27' as a string in php and find the nearest 5 dates in a table. The date in the table are saved as a date type.

推荐答案

您可以使用 ABS

SELECT ABS(DATEDIFF(myfield,'2010-04-27')) AS diff FROM mytable ORDER BY diff LIMIT 5;

这篇关于SQL最近日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！