Date Timezone PostgreSQL

  1. Home
  2. PostgreSQL
  3. Date Timezone
  4. To_char(yesterday
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=#