datetime arithmatic

Поиск
Список
Период
Сортировка
От Stuart
Тема datetime arithmatic
Дата
Msg-id 3AEDBA74.D13EB066@yahoo.com
обсуждение исходный текст
Список pgsql-general
Folks,

    I am new to postgresql 7.1 and like what I see so far.  How is datetime
arithmatic performed in postgres.  I have a table with start date/time
and end date/time(datetime data type) fields and want to set the default
end time to 1 hour later than the start time.  Is there a way to do
this.  My attempts to set the default value for the field using:

starttime datetime default now(),
endtime datetime default now() + xxx.xxx,

has yielded only either a datetime with time set to 00:00 or  only a
date!

Thanks for the help.

Stuart

В списке pgsql-general по дате отправления:

Предыдущее
От: per@nospam.mimer.se (Per Schröder)
Дата:
Сообщение: Re: Thread or not threads?
Следующее
От: "Erick Papadakis"
Дата:
Сообщение: How to install on Windows?