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