Re: timestamp

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: timestamp
Дата
Msg-id 1033993509.311.17.camel@lerlaptop
обсуждение исходный текст
Ответ на timestamp  ("Brian Ward" <brian0@verizon.net>)
Список pgsql-sql
On Sun, 2002-10-06 at 09:41, Brian Ward wrote:
> How do I create a time stamp column in a table that default to the current
> time
> when a row is inserted?
> I tried putting in now() as the default but I have something wrong
> with the syntax or something I think
> Any one have an example of a table creation script that has a timestamp
> column?
"comment_timestamp" timestamp(0) with time zone DEFAULT now()

that's a live one from a table I have.


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749



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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: [GENERAL] arrays
Следующее
От: Dan Langille
Дата:
Сообщение: Re: Need some SQL help