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)
Список
Дерево обсуждения
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
Дата: