Re: Help with syntax for timestamp addition

From: Scott Nixon <snixon(at)lssi(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help with syntax for timestamp addition
Date: 2004-11-22 14:17:23
Message-ID: 1101133043.23459.6.camel@talon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gary L. Burnore 2004-11-22 14:31:01 Re: RFD: comp.databases.postgresql.*
Previous Message Patrick Fiche 2004-11-22 14:12:26 Re: Help with syntax for timestamp addition