Re: Re: Incrementing a date type.

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Ian Harding <ianh(at)co(dot)pierce(dot)wa(dot)us>
Cc: danc(at)bspmail(dot)com, bruno(at)wolff(dot)to, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: Incrementing a date type.
Date: 2001-05-24 00:04:20
Message-ID: 20010524100420.B19482@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John 2001-05-24 01:33:46 Re: Cant get Perl Module loaded
Previous Message Martijn van Oosterhout 2001-05-23 23:57:57 Re: Estimating costs (was Functional Indices)