Re: Inputting relative datetimes

From: Vik Reykja <vikreykja(at)gmail(dot)com>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Inputting relative datetimes
Date: 2011-08-25 09:43:19
Message-ID: CALDgxVvWBh+NGDpCf2PjaZGG-G9CYUPagO62tubMGitjeJBa9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Aug 25, 2011 at 11:39, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)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'

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2011-08-25 10:08:25 Re: Inputting relative datetimes
Previous Message Dean Rasheed 2011-08-25 09:39:09 Inputting relative datetimes