Re: Date Math

On Monday 07 May 2007 3:19 pm, Rich Shepard wrote:
> On Mon, 7 May 2007, Tom Lane wrote:
> > It might be that converting those columns to interval is the best answer,
> > depending on what other processing needs to be done with them. But if
> > Rich wants to leave them as numbers, the above is the best way to convert
> > them to intervals on-the-fly.
>
>    Columns 'term' and 'process_time' converted to intervals. Just to
> confirm my understanding of today's lesson:
>
>      SELECT permit_nbr, title, date_issued, term, process_time from Permits
>             WHERE date_issued + term) < (CURRENT_DATE + process_time + '2
> week'::INTERVAL);
>
> is now correct syntax and use?
>
> Thanks all,
>
> Rich
Yes.
--
Adrian Klaver
aklaver@comcast.net