Re: More time manipulation..

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Gregory Seidman <gss+pg(at)cs(dot)brown(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: More time manipulation..
Date: 2002-11-18 23:53:19
Message-ID: 20021118235319.GA18497@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> } if I do "select Current_Date + interval '7 days'; I get:
> } 2002-11-25 00:00:00-06

Another option is to use:
select current_date + 7;
As long as you are moving by days (not months, years, hours etc.), this
is probably the simplest solution.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian Minton 2002-11-19 00:51:11 Re: signed/unsigned integers
Previous Message David Wall 2002-11-18 23:53:00 VARCHAR truncation