to_timestamp('197825July01:12am', 'YYYYDDFMMonthHH12:MIam') : to_timestamp « Date Timezone « PostgreSQL

1. PostgreSQL
2. Date Timezone
3. to_timestamp

to_timestamp('197825July01:12am', 'YYYYDDFMMonthHH12:MIam')

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

postgres=#
postgres=#
           
       

Related examples in the same category