Getting error function to_date(timestamp without time zone, unknown) does not exist

Question

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

 ERROR [JDBCExceptionReporter] ERROR: function to_date(timestamp without time zone, unknown) does not exist 

i had checked in my postgres by excecuting these to_date function

SELECT  to_date(createddate,'YYYY-MM-DD') FROM  product_trainings; 

it is giving me error function to_date does not exist

when i execute the same query in postgres 8.2 i am not getting error

Please help me to resolve these issue.

Answer 1

Three year later. You can cast

SELECT     to_date(cast(createddate as TEXT),'YYYY-MM-DD')  FROM       product_trainings; 

Answer 2

And even neater:

SELECT to_date(createddate::TEXT,'YYYY-MM-DD')  FROM product_trainings;