Re: Incrementing a date type. - Mailing list pgsql-general

From Ian Harding
Subject Re: Incrementing a date type.
Date
Msg-id sb0b7a8f.006@emgateways.co.pierce.wa.us
Whole thread Raw
In response to Incrementing a date type.  ("DC" <danc@bspmail.com>)
Responses Re: Re: Incrementing a date type.  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Except for Oct 28th if you live in a timezone that does daylight savings.

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: ianh@tpchd.org

>>> Bruno Wolff III <bruno@wolff.to> 05/23/01 06:59AM >>>
On Fri, May 18, 2001 at 12:17:47PM -0500,
  DC <danc@bspmail.com> wrote:
> I have an event that is three days long. In a table I want to be able to
> enter Friday date and have Saturdays and Sundays fill in automatically. It
> also has to check for the month/# of days in...

You can add intervals to timestamps. If you use an interval of 1 day, this will
probably do what you want.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Install with Apache/PHP (Was "Stubborn Multibyte")
Next
From: Tom Lane
Date:
Subject: Re: Vacuumdb message: AbortTransaction and not in-progress ...