select '2004-06-04 18:57:00+01' - now(); ?column? -------------------------- -3 days -00:00:25.633516 (1 row)