我需要那些将在15天后过期的结果 [英] I need Those result which is going to expire after 15 days

问题描述

我有一张表，其中包含一些酒店信息，并且每家酒店的有效期都有效.我需要那些结果，该结果将在15天后过期.这意味着在其有效期的15天之前.请给我一些思路，以进行上述逻辑操作.
在此先感谢

I have a table which contains some hotel information and each hotel valid on their valid to date.I need those result which is going to expire after 15 days.That means Before 15 days of their expiry date . Please Give me some idea to make procedure of above logic.
Thanks in advance

推荐答案

尝试:

SELECT * FROM Hotels WHERE expiryDate > GETDATE() AND expiryDate <= DATEADD(day, 15, GETDATE())

这篇关于我需要那些将在15天后过期的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！