Mysql query between and like query
<p>I had a table in which dates are storing in datetime format like '2016-06-29 00:58:12'. I have to find the data between two dates but the problem is that i stored this with time also so how can i get the output .. </p>

<p>I tried </p>

<pre><code>SELECT time_of_action FROM `trackvendoraction`  where time_of_action like '2016-06-29%'
union
SELECT time_of_action FROM `trackvendoraction`  where time_of_action like '2016-06-30%' 
</code></pre>

<p>i this above query i got the data for two dates now i had to apply the between query . how can i do this ? 
thanks </p>