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

From Martijn van Oosterhout
Subject Re: Re: Incrementing a date type.
Date
Msg-id 20010524100420.B19482@svana.org
Whole thread Raw
In response to Re: Incrementing a date type.  ("Ian Harding" <ianh@co.pierce.wa.us>)
List pgsql-general
On Wed, May 23, 2001 at 08:51:16AM -0700, Ian Harding wrote:
> Except for Oct 28th if you live in a timezone that does daylight savings.

What I do is add 18 hours and the cast to date, truncating it back. Then
dailylight saving has no effect.

> >>> 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.

--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Estimating costs (was Functional Indices)
Next
From: Tom Lane
Date:
Subject: Re: Estimating costs (was Functional Indices)