Re: epoch to show millseconds

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: epoch to show millseconds
Дата
Msg-id
25214.995385840@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
epoch to show millseconds Mars G Miro <mars@cannoncreek.com>
Re: epoch to show millseconds Tom Lane <tgl@sss.pgh.pa.us>
Re: epoch to show millseconds Grant <grant@conprojan.com.au>
Mars G Miro  writes:
> 	how do I make it accurate up to milliseconds value?

You don't.  current_timestamp depends on the time() system call,
which only returns a number accurate to one second.

There is a higher-precision current time function in 7.1, but I
forget the details ... see the docs.  IIRC it existed but was
buggy in 7.0, so you'll need to update.

			regards, tom lane
В списке pgsql-sql по дате отправления
От: Peter Eisentraut
Дата:
От: Tom Lane
Дата:
FAQ