title: Datetime variable type deprecated in PostgreSQL 9.0.x?
body: <p>I'm querying an external API and want to test out data inserts on a test server before moving to production.</p>
  
  <p>Currently, I'm trying to execute the following statement in Postgres's shell:</p>
  
  <pre><code>CREATE TABLE referrals (client_id VARCHAR(36), device_id VARCHAR(100), conversion_time DATETIME, acquisition_cost MONEY);
  </code></pre>
  
  <p>but it keeps failing on <code>DATETIME</code>.</p>
  
  <p>Since this doesn't work, would timestamp? If so, how do I modify timestamp's default behavior to take in preformatted dates and times?</p>