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

Three year later. You can cast

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