<p>I need to do a date comparison in Mysql without taking into account the time component i.e. i need to convert '2008-11-05 14:30:00' to '2008-11-05'</p>

<p>Currently i am doing this:</p>

<pre><code>SELECT from_days(to_days(my_date))
</code></pre>

<p>Is there a proper way of doing this?</p>

Yes, use the
date
function:
```
```
SELECT date(my_date)
```
```