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

From: Jon Sime <jsime(at)mediamatters(dot)org>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How do I do a dynamic - select now() + interval X days ?
Date: 2007-08-08 15:16:09
Message-ID: 46B9DE39.2030608@mediamatters.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rodrigo De León 2007-08-08 15:19:02 Re: How do I do a dynamic - select now() + interval X days ?
Previous Message Hajek, Nick 2007-08-08 15:01:37 Re: Transaction-Overflow