Re: [SQL] epoch to show millseconds - Mailing list pgsql-general

From Grant
Subject Re: [SQL] epoch to show millseconds
Date
Msg-id Pine.LNX.4.21.0107180831300.6081-100000@webster.conprojan.com.au
Whole thread Raw
List pgsql-general
> 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.


pgsql-general by date:

Previous
From: Keith Irwin
Date:
Subject: Re: Does dropping a column from a table mess up foreign keys?
Next
From: "Mitch Vincent"
Date:
Subject: Re: Re: epoch to show millseconds