CODEWITHSUNDEEP
sqlsql-servert-sql
JM1
JM1

Reputation: 1715

How do I return results of a date range of >=2 days?

I need to only pull records that have have a date span of 2 or more days. I have over 8K records I need to search through. What's the best way to do this please? I'm using SQL Server 2014.

SQL Fiddle

In case SQL Fiddle doesn't work: (I've had issues getting it to work lately.)

create table #DD
    (
     Event varchar(100),
     ResponseBegin date,
     ResponseEnd date
    )

insert  into #DD
        (Event, ResponseBegin, ResponseEnd)
values  ('Det', '20150201', '20150202'),
        ('Adm', '20160201', '20160204'),
        ('MM', '20120201', '20120205'),
        ('Det', '20160201', '20160207'),
        ('Det', '20160201', '20160201')

Data

enter image description here

Desired Results

enter image description here

Thank you.

Upvotes: 0

Views: 72

Answers (4)

Sahi
Sahi

Reputation: 1484

select *from #DD where DATEDIFF(D,ResponseBegin,ResponseEnd)>=2

Upvotes: 0

Rafael Dontal Gonçalez
Rafael Dontal Gonçalez

Reputation: 140

This might work:

SELECT * FROM DD WHERE ResponseEnd <= DATEADD(day, 2, ResponseBegin)

Upvotes: 0

Svperstar
Svperstar

Reputation: 497

Try

SELECT * FROM DD WHERE 
ResponseEnd <= DATEADD(day, 2, ResponseBegin)

Upvotes: 0

Juan
Juan

Reputation: 3705

You can do the following:

SELECT * FROM DD WHERE DateAdd(DAY, 2, ResponseBegin) <= ResponseEnd

Upvotes: 1

Related Questions