postgres=# SELECT to_timestamp('197825July01:12am', 'YYYYDDFMMonthHH12:MIam') AS correct_interpretation; correct_interpretation------------------------ 1978-07-25 01:12:00-07(1 row)postgres=#postgres=#