Mega Code Archive

 

Categories / PostgreSQL / Date Timezone

 

Get current date

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