using <= or >= in timestamp field in mysql

Question

I would like to select all records before 2014-03-22 date:

 where date < 2014-03-22 // what I need

but below code doesn't see 2013 year's records :

SELECT * FROM `tractions` WHERE YEAR(date) <= 2014  AND MONTH(date) <= 3 and  DAY(date) <= 22 and succ = 1

following link may help you stackoverflow.com/questions/696438/… — Abhishek
– Abhishek, Commented Aug 29, 2016 at 15:47
That second query is not only over-complicating things, it's completely wrong. — tadman
– tadman, Commented Aug 29, 2016 at 16:02

Tim Biegeleisen · Accepted Answer · 2016-08-29 15:46:07Z

2

Is there anything wrong with:

SELECT * FROM tractions
WHERE date < '2014-03-22'    -- place the date, correctly formatted, in quotes

Since this comparison doesn't use any functions, it will also allow you to use any indices setup on the date column.

answered Aug 29, 2016 at 15:46

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

1 Answer 1