Обсуждение: Re: [SQL] epoch to show millseconds

Поиск
Список
Период
Сортировка

Re: [SQL] epoch to show millseconds

От
Grant
Дата:
> Hi All
>
>     I've searched the archives, but it seems that there's no mention of this.
> Basically, what I want to do is to show the milliseconds value.

FAQ: How can I select the time with milliseconds?

binary_data=# select date_part('millisecond', timeofday()::timestamp);
date_part
------------------
534.253999999997

A person asked this question a while back in #Postgresql on IRC EFNet.