MySQL date comparison issue

Question

I have the date in this format in mySQL databse:

2011-02-21 14:40:03

But i have to compare only datepart of this dateandtime i.e:

2011-02-21

How???

score 4 · Accepted Answer · answered Mar 08 '11 at 06:29

4

A better solution is to use WHERE col >= '2011-02-21' AND col < '2011-02-22', so MySql can use a index if there is one present.

answered Mar 08 '11 at 06:29

The Scrum Meister

Yes, because everybody should [write queries for continuous periods as explicit range condition](http://use-the-index-luke.com/sql/where-clause/obfuscation/dates). – Markus Winand Mar 08 '11 at 06:55

score 3 · Answer 2 · answered Mar 08 '11 at 06:25

3

... where date(datetime_column) = '2011-02-21'

Here is the documentation

answered Mar 08 '11 at 06:25

Sarwar Erfan

2 Answers2