Trying to get dates between 2 dates in PHP using SQL

Question

I am using this query to get all the dates between 2 dates:

$getDates="SELECT daily_rate_date FROM daily_rates  WHERE daily_rate_date BETWEEN '".$checkOut."' AND '".$departureDate."' AND daily_rate_reservation=$reservationId;";

The thing is that if for example $checkOut = 03-03-2021 and $departureDate = 07-03-2021, I get the dates:

04-03-2021
05-03-2021
06-03-2021

but i also need the $checkOut date too to be included (but not the $departureDate) :

How can I accomplish that?

WHERE daily_rate_date >= '".$checkOut."' AND daily_rate_date < '".$departureDate."' ? See also how to Use prepared statements and parameterized queries — Syscall
– Syscall, Commented Mar 2, 2021 at 17:48
Almost duplicate (different language but basically the same), but I believe that this is the answer that you want. stackoverflow.com/a/43633362/498699 — Schleis
– Schleis, Commented Mar 2, 2021 at 17:49

eshirvana · Accepted Answer · 2021-03-02 17:50:01Z

0

then change your query to:

$getDates="SELECT daily_rate_date FROM daily_rates  
           WHERE daily_rate_date >= '".$checkOut."' 
           AND   daily_rate_date < '".$departureDate."' 
           AND   daily_rate_reservation=$reservationId;";

answered Mar 2, 2021 at 17:50

eshirvana

24.7k3 gold badges28 silver badges43 bronze badges

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

Comments

naghal · Accepted Answer · 2021-03-02 17:50:06Z

0

You could use >= and < operators instead of between for you use case.

$getDates="SELECT daily_rate_date FROM daily_rates  WHERE daily_rate_date >= '".$checkOut."' AND < '".$departureDate."' AND daily_rate_reservation=$reservationId;";

answered Mar 2, 2021 at 17:50

naghal

7266 silver badges24 bronze badges

Collectives™ on Stack Overflow

Trying to get dates between 2 dates in PHP using SQL

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related