epoch to show millseconds - Mailing list pgsql-sql

From Mars G Miro
Subject epoch to show millseconds
Date
Msg-id 01071208393000.07133@hellraiser.cannoncreek.com
Whole thread Raw
Responses Re: epoch to show millseconds  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: epoch to show millseconds  (Grant <grant@conprojan.com.au>)
List pgsql-sql
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.
When I do a:sample=# select date_part('epoch', current_timestamp); date_part----------- 994832815
how do I make it accurate up to milliseconds value? the above is only up to
seconds.This is on Postgresql-7.0.3, btw.Thanks!



cheers
mars
PS. pls CC me as I'm not subscribed


pgsql-sql by date:

Previous
From: Edipo Elder Fernandes de Melo
Date:
Subject: Re: Performance tuning in PostgreSQL?
Next
From: Carlos
Date:
Subject: Select distinct and order by.