How to select records form a table with current date and custom time range?
<p>I am having a table with seperate <code>date and time</code> column. I need to select all data from my table checking two condition</p>

<p><strong>1.records with current date(todays date).</strong></p>

<p><strong>2.records with custom time range.</strong></p>

<p>This is my table structure</p>

<pre><code>+------------+------------+---------------------+-------------------+--------------------+
|    id      |   item     |    description      |    bill_date      |       bill_time    |
+------------+------------+---------------------+-------------------+--------------------+
|    1       |    x       |    test             |   2016-04-15      |     12:05:00       |
+------------+------------+---------------------+-------------------+--------------------+
|    2       |    y       |    test1            |   2016-04-15      |     01:10:44       |
+------------+------------+---------------------+-------------------+--------------------+
|    3       |    z       |    test2            |   2016-04-16      |     05:10:10       |
+------------+------------+---------------------+-------------------+--------------------+
</code></pre>

<p>I could select time range using this mysql query</p>

<pre><code>SELECT * FROM `bill_item` WHERE `bill_time` BETWEEN '12:00:00' AND '06:00:00'
</code></pre>

<p>this returns <code>2,3 record</code> now I <strong>need to check if the record is todays record</strong>. How to do this? </p>