Using Intervals To Offset Time
> select now() - '2 hours'::interval as earlier;
earlier
-------------------------------
2015-06-12 21:17:43.678822-05> select now() - interval '2 hours' as earlier;
earlier
-------------------------------
2015-06-12 21:17:43.678822-05Last updated