Mega Code Archive

 

Categories / PostgreSQL / Date Timezone

 

Date_trunc(year, now())

postgres=# postgres=# SELECT date_trunc('year', now());        date_trunc ------------------------  2006-01-01 00:00:00-08 (1 row) postgres=#