Обсуждение: How do I do a dynamic - select now() + interval X days ?

Поиск
Список
Период
Сортировка

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

От
"Abraham, Danny"
Дата:
Thanks

Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
danny_abraham@bmc.com

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

От
Jon Sime
Дата:
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/

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

От
Kristo Kaiv
Дата:

On 08.08.2007, at 18:16, Jon Sime wrote:

Abraham, Danny wrote:
Thanks

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

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

-Jon

test=# select (3||' day')::interval;
interval
----------
3 days
(1 row)

-- 
Senior Systems Developer
Media Matters for America

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)


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

От
Rodrigo De León
Дата:
On Aug 8, 9:54 am, danny_abra...@bmc.com ("Abraham, Danny") wrote:
> Thanks

Please be more specific...