Date Timezone PostgreSQL

  1. Home
  2. PostgreSQL
  3. Date Timezone
  4. Get current date
postgres=# SELECT current_date, 'now'::date AS date;
    date    |    date
------------+------------
 2006-10-08 | 2006-10-08
(1 row)
postgres=#