title: How to create a view to refine data from Customer Meter data on ORACLE
body: <p>I have a METER_DATA table or ORACLE contains information</p>
  
  <p><a href="http://i.stack.imgur.com/iN6LG.png" rel="nofollow">METER_DATA data</a></p>
  
  <p>I want to refine data base on SAMPLE_TIME with rule minute = 0 or 30 only (so if Minute >= 30 then Min = 30; else minute = 0). For examples:</p>
  
  <pre><code>+ 6/28/2016  12:00:12 -&gt; 6/28/2016  12:00:00
  + 6/28/2016  12:20:12 -&gt; 6/28/2016  12:00:00
  + 6/28/2016  12:30:00 -&gt; 6/28/2016  12:30:00
  </code></pre>
  
  <p>How can I create a VIEW using PL/SQL that got results:</p>
  
  <p><a href="http://i.stack.imgur.com/ORqst.png" rel="nofollow">RESULTS data</a></p>
  
  <p>Thank you very much.</p>