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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Estimating costs (was Functional Indices)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Estimating costs (was Functional Indices)