Re: three timestamps/table, use of 'now' in table creation statement

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: three timestamps/table, use of 'now' in table creation statement
Дата
Msg-id 20030116212158.GA27905@wolff.to
обсуждение исходный текст
Ответ на three timestamps/table, use of 'now' in table creation statement  (Dennis Gearon <gearond@cvc.net>)
Список pgsql-general
On Thu, Jan 16, 2003 at 13:00:44 -0800,
  Dennis Gearon <gearond@cvc.net> wrote:
> What would it be rounded to, for the sake of knowledge?
>
> I will change all my table defintions to timestamp(0). BTW, what is the default resolution? I'm am
> in the process of RTFM'ing, don't worry.

I was just pointing out that there might be a difference between the two
cases. If you don't care about rounding, you can just use current_timestamp
instead of current_timestamp(0).

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

Предыдущее
От: "Orr, Steve"
Дата:
Сообщение: Re: Server error and deadlocks
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Server error and deadlocks