Cast a String to Timestamp in PostgreSQL
If storing a date/timestamp in a varchar or text field in postgres, the to_timestamp() function will let you access the value as a ‘real’ date. The second parameter tells the function the format of your string:
SELECT to_timestamp('2008-08-01', 'YYYY-MM-DD') AS date;