Mysql query select between dates php not working

Question

So I have the following sql query

 SELECT * FROM log WHERE Date > 2013-12-12 00:00:00 AND Date < 2014-02-08 00:00:00 LIMIT 10

Where the log table has a column Date in the format Y-m-d H:i:s

One entry in the database has a Date of 2014-02-06 21:48:10 which should be picked up by this query no? But it's not.

Is there anything I'm missing here?

Thanks

Are the Date columns of type DATETIME?

Phil
– Phil

2014-02-07 04:21:20 +00:00
Commented Feb 7, 2014 at 4:21 — Phil
– Phil, Commented Feb 7, 2014 at 4:21

Nouphal.M · Accepted Answer · 2014-02-07 04:21:12Z

3

You forgot the quotes

SELECT * FROM log WHERE `Date` > '2013-12-12 00:00:00' AND `Date` < '2014-02-08 00:00:00' LIMIT 10

answered Feb 7, 2014 at 4:21

Nouphal.M

6,3281 gold badge20 silver badges28 bronze badges

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

6 Comments

Belgin Fish Over a year ago

Knew it would be something stupid like that, thank you

Nouphal.M Over a year ago

you could have used BETWEEN

Phil Over a year ago

@Nouphal.M Then that would be different to the OP's logic. BETWEEN would be Date >= '2013-12-12 00:00:00' AND Date <= '2014-02-08 00:00:00'. See the difference?

Nouphal.M Over a year ago

@Phil, yes thats true

Belgin Fish Over a year ago

I had originally used between but as it was not working I switched to > and < thinking that would solve the issue, which it did not as the issue was with the quotes. I will be switching back to between.

|

Nagaraj S · Accepted Answer · 2014-02-07 04:24:59Z

2

you miss the quotes

Do like this for Date Range Selection

SELECT * FROM log  WHERE `DATE` BETWEEN "2013-12-12" AND "2014-02-08" LIMIT 10;

edited Feb 7, 2014 at 4:24

Nagaraj S

13.5k6 gold badges36 silver badges53 bronze badges

answered Feb 7, 2014 at 4:21

Nambi

12k4 gold badges40 silver badges50 bronze badges

1 Comment

Phil Over a year ago

Note; BETWEEN is not the same (it is inclusive)

Collectives™ on Stack Overflow

Mysql query select between dates php not working

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related