PostgreSQL/Date Timezone/current date

Get current date

postgres=# SELECT current_date, "now"::date AS date;
    date    |    date
------------+------------
 2006-10-08 | 2006-10-08
(1 row)
postgres=#