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