MySQL select by date range query - unexpected output

Question

Why MySQL in following query:

select * from `tips` 
where `tips`.`tipster_id` = '16' 
and `result` <> '0' 
and `date` >= '2014-02-01' 
and `date` <= '2014-02-28'

excludes rows with date 2014-02-28 ???

Dirk Huber · Accepted Answer · 2015-01-03 18:09:04Z

2

Do you store time values in that column? I guess that 2014-02-28 is this is the same as 2014-02-28 00:00:00.

So date values with a time after 00:00:00 will not be included.

answered Jan 3, 2015 at 18:09

Dirk Huber

9126 silver badges13 bronze badges

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

1 Comment

Yes, I store time also, and time is not 00:00:00 but something like 15:20:00. Ok, I know what is the problem, thanks.

Oleksii Golub · Accepted Answer · 2015-01-03 18:12:51Z

1

I use this version

select * from `tips` 
where `tips`.`tipster_id` = '16' 
and `result` <> '0' 
and `date` >= '2014-02-01 00:00:00' 
and `date` <= '2014-02-28 23:59:59'

answered Jan 3, 2015 at 18:12

Oleksii Golub

1617 bronze badges