Query to get the result between two date time stamp
<p>I want to fetch some records which should give results based on certain time.</p>

<p>That means from <code>2.30 Am to 6.00 AM</code>. </p>

<p>I tried using the <strong>between</strong> function, but i am not getting.</p>

<pre><code> MTRDCRE between (to_char(to_date('16-03-2016 02:50:00', 'dd-mm-yyyy hh24:mi:ss')) , to_char(to_date('16-03-2016 05:50:00', 'dd-mm-yyyy hh24:mi:ss')))
</code></pre>