Re: Incrementing a date type.

From: "Ian Harding" <ianh(at)co(dot)pierce(dot)wa(dot)us>
To: <danc(at)bspmail(dot)com>, <bruno(at)wolff(dot)to>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Incrementing a date type.
Date: 2001-05-23 15:51:16
Message-ID: sb0b7a8f.006@emgateways.co.pierce.wa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)tpchd(dot)org

>>> Bruno Wolff III <bruno(at)wolff(dot)to> 05/23/01 06:59AM >>>
On Fri, May 18, 2001 at 12:17:47PM -0500,
DC <danc(at)bspmail(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2001-05-23 15:55:00 Re: Estimating costs (was Functional Indices)
Previous Message Tom Lane 2001-05-23 15:45:48 Re: A Couple of Questions on Blobs