Date Timezone PostgreSQL

  1. Home
  2. PostgreSQL
  3. Date Timezone
  4. Date_trunc(year, now())
postgres=#
postgres=# SELECT date_trunc('year', now());
       date_trunc
------------------------
 2006-01-01 00:00:00-08
(1 row)
postgres=#