Re: datetime arithmatic

Поиск
Список
Период
Сортировка
От Gyozo Papp
Тема Re: datetime arithmatic
Дата
Msg-id 028101c0d56d$e4e5f080$4647c5d5@jaguar
обсуждение исходный текст
Ответ на datetime arithmatic  (Stuart <sfbarbee@yahoo.com>)
Список pgsql-general
Maybe this helps you:

starttime datetime default now(),
endtime datetime default (now() + interval('1 hour'))

----- Original Message -----
From: "Stuart" <sfbarbee@yahoo.com>
To: <pgsql-general@postgresql.org>
Sent: 2001. április 30. 21:18
Subject: [GENERAL] datetime arithmatic


> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


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

Предыдущее
От: "Christian Marschalek"
Дата:
Сообщение: RE: [ADMIN] Primary Keys
Следующее
От: Holger Klawitter
Дата:
Сообщение: Re: Trying to get jdbc to work