Mysql query date between dates

Question

I want to select the records that have a specific in between date, let me explain this in an example: I have this table:

contracts
id | date_start | date_finish
1  | 2011-01-01 | 2011-01-15
2  | 2012-02-15 | 2012-03-15
3  | 2012-02-16 | 2012-02-25

I want to show the contracts that were open in this date '2012-02-17', if I do this query it would output contracts 2 and 3, if I searched this date '2012-03-14' it would output contract 2...how can I make this query?

Thanks!!

dcp · Accepted Answer · 2014-01-14 16:59:44Z

4

SELECT * FROM contracts WHERE your_date BETWEEN date_start AND date_finish

However, I think "if I searched this date '2012-03-14' it would output contract 3.." should ouptut contract 2, since 2012-03-14 is between 2012-02-15 and 2012-03-15.

answered Jan 14, 2014 at 16:59

dcp

55.7k24 gold badges149 silver badges169 bronze badges

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

1 Comment

joseagaleanoc Over a year ago

I didn't know that I could use between like that...THANKS!!

Collectives™ on Stack Overflow

Mysql query date between dates

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related