Select all entries younger than 7 days

Question

I want to select all entries from [Orders]which have [Submissiondate]less than 7 days.

I am completely at a dead end. This is the request that I execute:

SELECT * FROM [Orders] WHERE ([SubmissionDate] < @SubmissionDate)

Does not work.

+5

user1269384 Jun 30 '12 at 18:45

4 answers

Andriy m · Answer 1 · 2012-06-30T22:29:38+0000

If you want the rows with to SubmissionDatebe between @SubmissionDateand @SubmissionDate - 7 days, then I would implement this in Transact-SQL:

WHERE [SubmissionDate] BETWEEN DATEADD(DAY, -7, @SubmissionDate)
                           AND @SubmissionDate

Note what BETWEENimplies >=and <=. If you need strict inequalities, do it something like this:

WHERE [SubmissionDate] > DATEADD(DAY, -7, @SubmissionDate)
  AND [SubmissionDate] < @SubmissionDate

Luis Quijada · Answer 2 · 2012-07-01T11:39:44+0000

, sql @SubmissionDate - ( ). , [Orders] , 7 :

SELECT * FROM [Orders] WHERE ([SubmissionDate] >= DATEADD(DD, -7, DATEADD(dd, 0, DATEDIFF(dd, 0, @SubmissionDate))))

:

, "" - ( SO).

DATEADD(dd, 0, DATEDIFF(dd, 0, @SubmissionDate))

codingbiz · Answer 3 · 2012-06-30T19:02:51+0000

SELECT * FROM [Orders] WHERE  datediff(d,SubmissionDate,GETDATE()) > 7

GetDate() - , d -

select datediff(d,'2012/06/23',GETDATE())

7, 7

Vikas Chauhan · Answer 4 · 2017-09-21T08:25:50+0000

SELECT * FROM [Orders] WHERE [submit_date] <NOW () - INTERVAL 7 DAY;