MySQL query to get data in date range specified in days count

Question

I have a table named questions. In that table there is a field call question_date. Field is datetime.

I want to check all the question those are asked between 5-7 days only.

I have tried below query but I am getting blank output. No records was there.

SELECT * FROM `questions` WHERE `question_date` < NOW() - INTERVAL 5 DAY AND question_date >= NOW()

SELECT * FROM `questions` WHERE `question_date` = DATE(DATE_ADD(NOW(), INTERVAL -2 DAY))

I have checked the below questions:

mysql query to get birthdays for next 10 days

SQL statement to get the date next 2 days from now

Can you share sample data and expected response – Shuddh Sep 16 '17 at 18:16 — Shuddh, Sep 16 '17 at 18:16
You need exactly 5 days or between 5 and 7? – Ivar Sep 16 '17 at 18:16 — Ivar, Sep 16 '17 at 18:16

score 3 · Accepted Answer · answered Sep 16 '17 at 18:18

3

Use this

SELECT * FROM `questions` 
WHERE `question_date` < date_sub(NOW(), INTERVAL 5 DAY) AND question_date >= date_sub(NOW(), INTERVAL 7 DAY)

answered Sep 16 '17 at 18:18

Shuddh

1,920
2
19
30

Thanks for your answer. Voted up. Let me try. – Roxx Sep 16 '17 at 18:21
if you can share the sample data and expected response. I can help you with proper ans. – Shuddh Sep 16 '17 at 18:23

score -1 · Answer 2 · answered Sep 16 '17 at 18:31

-1

You can try same below: select * from demo where DAT between DATE_SUB('2017-02-04', INTERVAL 2 DAY) and '2017-02-04'

answered Sep 16 '17 at 18:31

Vu Minh Vuong

81
1
1
6

MySQL query to get data in date range specified in days count

2 Answers2