foobar=# select now() - '2002-10-05 08:52:38.278458-06'::timestamptz; ?column? ----------------- 00:00:23.901656