更新时间:2023-02-25 19:49:28
您可以使用以下查询:
select * from test
其中DateDiff(dd,GETDATE(),MyDateColumn)=(
从Test WHERE MyDateColumn> GETDATE选择TOP 1 Min(DateDiff(dd,GETDATE(),MyDateColumn)) ()
)
子查询将获得最近即将到来的日期的天数差异。然后外部查询将选择具有该最小差异的记录。
You can use the following query:
select * from test
where DateDiff(dd, GETDATE(), MyDateColumn) = (
select TOP 1 Min(DateDiff(dd, GETDATE(), MyDateColumn)) from Test WHERE MyDateColumn > GETDATE()
)
The subquery will get the difference in number of days for the nearest upcoming date. Then the outer query will select the records with that minimum difference.