Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I do a dynamic - select now() + interval X days ? - Mailing list pgsql-admin

From Jon Sime
Subject Re: How do I do a dynamic - select now() + interval X days ?
Date
Msg-id 46B9DE39.2030608@mediamatters.org
Whole thread Raw
In response to How do I do a dynamic - select now() + interval X days ?  ("Abraham, Danny" <danny_abraham@bmc.com>)
Responses Re: How do I do a dynamic - select now() + interval X days ?  (Kristo Kaiv <kristo.kaiv@skype.net>)
List pgsql-admin
Tree view 
Abraham, Danny wrote:
> Thanks

For doing that based on an arbitrary value, just do the following:

    select now() + interval '1 day' * X;

-Jon

--
Senior Systems Developer
Media Matters for America
http://mediamatters.org/

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql Login problem
Next
From: Kristo Kaiv
Date:
Subject: Re: How do I do a dynamic - select now() + interval X days ?