Mega Code Archive

 

Categories / PostgreSQL / Date Timezone

 

To_timestamp(197825July01

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