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