Check If the Current Date Is Between Two Dates + MySQL Select Query

Check if the current date is between two dates + mysql select query

Try this :: This will solve your problem

SELECT * FROM `table` WHERE active=0 AND CURDATE() between dateStart and dateEnd

Check if a date falls between two dates in MySQL database?

The result of

      SELECT EXISTS(SELECT *
       FROM blackout where '2019-09-13' BETWEEN StartDate AND EndDate 
       AND city="SF" AND class="2");

is 1

And for

      SELECT EXISTS(SELECT *
       FROM blackout where '2017-09-13' BETWEEN StartDate AND EndDate 
       AND city="SF" AND class="2");

You get an 0

How do I query between two dates using MySQL?

Your second date is before your first date (ie. you are querying between September 29 2010 and January 30 2010). Try reversing the order of the dates:

SELECT *
FROM `objects`
WHERE (date_field BETWEEN '2010-01-30 14:15:55' AND '2010-09-29 10:15:55')

Select data between a date/time range

You need to update the date format:

select * from hockey_stats 
where game_date between '2012-03-11 00:00:00' and '2012-05-11 23:59:00' 
order by game_date desc;

Check if Date is between two dates in mysql

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

MySQL query - check between two dates without needing to retrieve rows

I phrased the question slightly wrong, in that I was trying to return the result of a conditional. Once I realised how to ask google the right thing, I quickly came up with this solution:

SELECT (CASE WHEN this_date BETWEEN beginning_date AND end_date THEN 1 ELSE 0 END) AS date_result

Thanks to the other people who answered, your input put my thinking on the right track.

SELECT MySQL rows where today's date is between two DATE columns

You will find a lot of people using between operator, but I prefer using a simple AND operator.

I do that because although the between operator IS inclusive, simple dates (2012-04-10) can be counted as being midnight, and will thus not be inclusive.

So this should work just fine and will always include the boundaries of the date range:

SELECT * FROM table WHERE from_date <= '2012-04-10' AND to_date >= '2012-04-10'

How to get list of dates between two dates in mysql select query

Try:

select * from 
(select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_date from
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4) v
where selected_date between '2012-02-10' and '2012-02-15'

-for date ranges up to nearly 300 years in the future.

[Corrected following a suggested edit by UrvishAtSynapse.]

---

Related Topics