title: Getting error function to_date(timestamp without time zone, unknown) does not exist
body: <p>Recently i have migrated my postgres from 8.2 to 8.4. when I run my application and tried to
  login i am getting these error</p>
  
  <pre><code> ERROR [JDBCExceptionReporter] ERROR: function to_date(timestamp without time zone, unknown) does not exist
  </code></pre>
  
  <p>i had checked in my postgres by excecuting these to_date function</p>
  
  <pre><code>SELECT  to_date(createddate,'YYYY-MM-DD') FROM  product_trainings;
  </code></pre>
  
  <p>it is giving me error  function to_date does not exist</p>
  
  <p>when i execute the same query in postgres 8.2 i am not getting error</p>
  
  <p>Please help me to resolve these issue.</p>