Mysql query between date query

Question

I am using this query but it is not selecting the end date data, date 2018-04-07 and 2018-04-08 data selecting but not 2018-04-09

SELECT * 
  FROM ticket 
 WHERE created_date >= '2018-04-07'
   AND created_date <= '2018-04-09'

Since you don't specify a time part '00:00:00' is assumed. Isn't it easier to do < '2018-04-10' — pritaeas
– pritaeas, Commented Apr 18, 2018 at 14:02

nacho · Accepted Answer · 2018-04-18 14:27:42Z

2

Use this query

SELECT * 
FROM `ticket` 
WHERE `created_date` >= '2018-04-07 00:00:00:' AND `created_date` <= '2018-04-09 23:59:59'

nacho

5,3772 gold badges28 silver badges35 bronze badges

answered Apr 18, 2018 at 14:08

Devsi Odedra

5,3421 gold badge25 silver badges38 bronze badges

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

1 Answer 1