title: Remove seconds from current date in Redshift (PostgreSQL)
body: <p>In Amazon Redshift I'm looking to convert the current timestamp to have 0 seconds.  That is go from this:</p>
  
  <pre><code>2013-12-17 12:27:50
  </code></pre>
  
  <p>to this:</p>
  
  <pre><code>2013-12-17 12:27:00
  </code></pre>
  
  <p>I have tried the following:</p>
  
  <pre><code>SELECT dateadd(second, -(date_part(second, getdate())), getdate());
  ERROR:  function pg_catalog.date_add("unknown", double precision, timestamp without time zone) does not exist
  HINT:  No function matches the given name and argument types. You may need to add explicit type casts.
  
  SELECT dateadd(second, -cast(date_part(second, getdate()) as double precision), getdate());
  ERROR:  function pg_catalog.date_add("unknown", double precision, timestamp without time zone) does not exist
  HINT:  No function matches the given name and argument types. You may need to add explicit type casts.
  
  SELECT getdate() - date_part(second, getdate());
  ERROR:  operator does not exist: timestamp without time zone - double precision
  HINT:  No operator matches the given name and argument type(s). You may need to add explicit type casts.
  </code></pre>
  
  <p>I'm probably missing a very simple way of doing this!  Does anyone have any suggestions, please?</p>