Mega Code Archive

 

Categories / PostgreSQL / Date Timezone

 

To_date(198025thJune, YYYYDDthMonth)

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