date_trunc('year', now()) : date_trunc « Date Timezone « PostgreSQL

1. PostgreSQL
2. Date Timezone
3. date_trunc

date_trunc('year', now())

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

postgres=#

           
       

Related examples in the same category