Mega Code Archive

 

Categories / PostgreSQL / Date Timezone

 

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=#