Re: incrementing and decrementing dates by day increments

On Sat, 25 Oct 2003, Neil Zanella wrote:

> Hello,
>
> I know that PostgreSQL, like most database management systems, has a
> function
> call called NOW() that returns the current date. Is there a way to
> return a datein PostgreSQL such that the output is in ISO 8601 format
> (Unix 'date -I' format)but such that the date is not "today"'s date
> but the date two days ago or five
> days ahead of now? I have tried something like NOW() + 5 but that did
> not work
> (because the data types are incompatible, and SELECT NOW() +
> '0000-00-01' does
> not work either. I get the error:


If you want a date, I'd suggest something like
 CURRENT_DATE+5

The reason this works while, now()+5 doesn't is that now() doesn't return
a date, but a timestamp type (including time).

If you want time information, then probably
 CURRENT_TIMESTAMP + INTERVAL '5 days'