title: How to INSERT now() + INTERVAL in Postgres 9.x
body: <p>I'm trying to <code>INSERT</code> a future date into a <code>timestamp with time zone</code> column in a table in Postgres 9.6.2. I'd like this date to be the current transaction time plus an arbitrary interval, such as 1 hour.
  I understand how to do date/time arithmetic in a <code>SELECT</code> statement, but the same syntax of <code>NOW() + INTERVAL '1 hour'</code> does not seem to be valid in an <code>INSERT</code> statement.</p>
  
  <p>Aside from accomplishing this at the application level, is it possible to accomplish this using a single <code>INSERT</code> statement using date/time arithmetic? If not, what would best practice be in this situation?</p>