title: How to round current time in teradata and insert into timestamp(6) fields
body: <p>I have a table  with date fields of <code>timestamp(6)</code> fields .  </p>
  
  <pre><code>create table test_time 
  (
    t1  timestamp(6)  format 'mm/dd/yyyy hh:mm:si' ,
  );  
  </code></pre>
  
  <p>I want to insert into this table with current date and time rounded.<br>
  i.e. say for example if the current date time is  <code>08/07/2014 10:34:56</code> then  the value in the table should be  <code>08/07/2014 10:00:00</code> .<br>
  (or) if current data and time is  <code>08/07/2014 10:54:56</code>   then also the value should be<br>
  <code>08/07/2014 10:34:56</code>  </p>