On Thu, Aug 25, 2011 at 11:39, Dean Rasheed <dean.a.rash...@gmail.com>wrote:
> My first thought was to have some general way of adding or subtracting > an interval at the end of an input timestamp, eg. by adding another > couple of special values - "plus <interval>" and "minus <interval>". > This would allow things like: > > TIMESTAMPTZ 'today minus 5 days' > TIMESTAMPTZ 'now plus 2 hours' > Funny you should mention intervals... timestamptz 'today' - interval '5 days' timestamptz 'now' + interval '2 hours'