title: Oracle Add 1 hour in SQL
body: <p>I am just trying to add 1 hour to a value, it is kind of complicated on where and why i am doing this but basically i just need to query something like this </p>
  
  <pre><code>select DATE_ADD(hh,1,'2014-10-15 03:30:00 pm') from dual
  </code></pre>
  
  <p>I keep reading old articles that say to use dateAdd or date_add but I keep getting invalid identifier errors. </p>