Mega Code Archive

 

Categories / PostgreSQL / Date Timezone

 

Date_trunc(hour, now())

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