to_date('198025thJune', 'YYYYDDthMonth') : Date Time Format « Date Timezone « PostgreSQL






  1. PostgreSQL
  2. Date Timezone
  3. Date Time Format

to_date('198025thJune', 'YYYYDDthMonth')


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

postgres=#








Related examples in the same category

1.to_char(now(), 'HH:MI PM')
2.to_char('yesterday'::timestamp, 'FMMonth FMDDth')
3.to_char(now(), 'Dy (Day), Mon (Month)')
4.to_char(start_date, 'FMMonth FMDDth, YYYY')
5.to_char(start_date, 'YYYY-MM-DD')
6.to_char(start_date, 'Y,YYY "years" A.D.')