postgres=#postgres=# SELECT to_date('198025thJune', 'YYYYDDthMonth') AS correct_interpretation; correct_interpretation------------------------ 1980-06-25(1 row)postgres=#