to_char(now(), 'Dy (Day), Mon (Month)')
postgres=# SELECT to_char(now(), 'Dy (Day), Mon (Month)') AS abbreviations,
postgres-# to_char('yesterday'::timestamp, 'FMMonth FMDDth') AS yesterday,
postgres-# to_char('yesterday'::timestamp, 'FMDDth FMMonth') AS "yesterday UK";
abbreviations | yesterday | yesterday UK
----------------------------------+-------------+--------------
Sun (Sunday ), Oct (October ) | October 7th | 7th October
(1 row)
postgres=#
postgres=#
Related examples in the same category