如何在特定范围的同一列中列出datediff [英] How to list datediff within the same column of specific range

问题描述

请让我们知道以下数据，我想选择7天之间的日期范围

pls let know for example below data , I want to select the date range between only 7 days

FeedID  Ticket_ID   FeedbackBy  FeedbackTime    FeedbackType
17  60557   3567    1/23/15 4:12 AM USER
19  60576   7931    1/23/15 12:17 PM    USER
95  60580   1524    2/22/15 9:41 AM USER
7   60586   6796    1/7/15 5:36 AM  USER
9   70843   7039    1/8/15 4:25 AM  USER
8   70869   7696    1/7/15 7:06 AM  USER

推荐答案

尝试：

Try:

SELECT * FROM MyTable WHERE FeedBackTime BETWEEN DATEADD(dd, -7, GETDATE()) AND GETDATE()

这篇关于如何在特定范围的同一列中列出datediff的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！