Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with syntax for timestamp addition - Mailing list pgsql-general

From Scott Nixon
Subject Re: Help with syntax for timestamp addition
Date
Msg-id 1101133043.23459.6.camel@talon
Whole thread Raw
In response to Re: Help with syntax for timestamp addition  ("Patrick Fiche" <patrick.fiche@aqsacom.com>)
List pgsql-general
Tree view 
> Have a try at this syntax
>
> SELECT number
> FROM procedures
> WHERE date + CAST( numdays || ' days' AS interval ) <= CURRENT_TIMESTAMP;
>
> Patrick
>

Cool!  Thanks....that works perfectly.

-Scott

pgsql-general by date:

Previous
From: "Patrick Fiche"
Date:
Subject: Re: Help with syntax for timestamp addition
Next
From: Ian Barwick
Date:
Subject: Re: Help with syntax for timestamp addition