Check if Date is between two dates in mysql [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 8 years ago.

Improve this question

I have a mysql record with the columns start_date and end_date. Now I have a date (as example 2017-08-03) and i want to ask if this date is between the start_date and end_date in my mysql table.

Is this possible?

select * from tab where start_date<='2017-08-03' and end_Date>='2017-08-03' — Imran Ahmad Shahid
– Imran Ahmad Shahid, Commented Aug 3, 2017 at 9:27
You can use WHERE date BETWEEN start_date AND end_date. stackoverflow.com/questions/1080207/… — theCakeCoder
– theCakeCoder, Commented Aug 3, 2017 at 9:28
SELECT * FROM objects WHERE (date BETWEEN start_date_field AND end_date_field) — Krishna Gupta
– Krishna Gupta, Commented Aug 3, 2017 at 9:29
Possible duplicate of Mysql: Select all data between two dates — theCakeCoder
– theCakeCoder, Commented Aug 3, 2017 at 9:29
Instead of naively asking “is this possible”, next time please just type your question title into Google ... And please go read How to Ask - among other things, it explains to you what minimal effort you are expected to make before asking here. — C3roe
– C3roe, Commented Aug 3, 2017 at 9:33

Jens · Accepted Answer · 2017-08-03 09:48:24Z

5

Use between:

SELECT * FROM events 
  WHERE '2012-01-18' between start_date AND end_date

BTW: Take care of time part if start and end are datetime types

edited Aug 3, 2017 at 9:48

answered Aug 3, 2017 at 9:28

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chandra Kumar · Accepted Answer · 2017-08-03 09:27:13Z

1

You can use this:

SELECT * FROM events 
  WHERE start_date<='2012-01-18'
  AND end_date>='2012-01-18'

answered Aug 3, 2017 at 9:27

Chandra Kumar

4,2131 gold badge19 silver badges26 bronze badges

Comments

H.M Maruf · Accepted Answer · 2017-08-03 09:31:20Z

1

SELECT *
FROM `yourtable`
WHERE (your_found_date BETWEEN 'start_date' AND 'end_date')

answered Aug 3, 2017 at 9:31

H.M Maruf

7512 bronze badges

Collectives™ on Stack Overflow

Check if Date is between two dates in mysql [closed]

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related