title: PostgreSQL Insert timestamp using today's date but specific hour
body: <p>I had this statement for SQLSERVER which inserts into a DateTime column, today's date but a specific hour.</p>
  
  <pre><code>INSERT INTO session VALUES(
  SMALLDATETIMEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), DAY(GETDATE()), 12, 0), 1, 1);
  </code></pre>
  
  <p>I am trying to achieve the same result in PostgreSQL but I can only find this</p>
  
  <pre><code>INSERT INTO sessions VALUES(current_timestamp, 1, 1)
  </code></pre>
  
  <p>Which inserts the current date and time.</p>
  
  <p>How would I be able to do this in PostgreSQL?</p>