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






  1. PostgreSQL
  2. Date Timezone
  3. date_trunc

date_trunc('hour', now())


postgres=#
postgres=# SELECT date_trunc('hour', now());
       date_trunc
------------------------
 2006-10-08 15:00:00-07
(1 row)

postgres=#
postgres=#








Related examples in the same category

1.date_trunc('minute', now())
2.date_trunc('year', now())