title: How to insert current datetime in postgresql insert query
body: <pre><code>INSERT into Group (Name,CreatedDate) VALUES ('Test',UTC_TIMESTAMP(), 1);
  </code></pre>
  
  <p>This is the query I have used for mysql to insert current date time.
  When I am using this in postgresql, I am getting below error.</p>
  
  <pre><code>    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
  ********** Error **********
  
  ERROR: function utc_timestamp() does not exist
  SQL state: 42883
  </code></pre>
  
  <p>I have tried like below using <code>now()</code>, however it is inserting like <code>"2016-07-07 17:01:18.410677"</code>. I need to insert in <code>'yyyymmdd hh:mi:ss tt'</code> format.</p>
  
  <pre><code>INSERT into Group (Name,CreatedDate) VALUES ('Test',UTC_TIMESTAMP(), 1);
  </code></pre>
  
  <p>How to insert current date time in insert query of postgresql in above format ?</p>