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