Re: Re: Incrementing a date type.
| От | Martijn van Oosterhout |
|---|---|
| Тема | Re: Re: Incrementing a date type. |
| Дата | |
| Msg-id | 20010524100420.B19482@svana.org обсуждение |
| Ответ на | Re: Incrementing a date type. ("Ian Harding" <ianh@co.pierce.wa.us>) |
| Список | 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 по дате отправления: