title: How to convert time without time zone to timestamp without time zone?
body: <p>I need to convert couple of columns in one table in PSQL and I really dont want to drop the table to fix this (thats my last resort). Is there a way to do this, because when I write:</p>
  
  <pre><code>    ALTER TABLE table ALTER TABLE column type TIMESTAMP without time zone using column::TIMESTAMP without time zone; 
  </code></pre>
  
  <p>it doesnt work, says:</p>
  
  <pre><code>    ERROR:cannot cast type time without time zone to timestamp without time zone.
  </code></pre>
  
  <p>P.S. If its possible, I would like to avoid dropping columns because I already use indexes of those columns.</p>