Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6HCEaa05614 for ; Tue, 17 Jul 2001 08:14:36 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from hellraiser.cannoncreek.com ([202.78.79.201]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6C0TZa36607 for ; Wed, 11 Jul 2001 20:29:35 -0400 (EDT) (envelope-from mars@hellraiser.cannoncreek.com) Received: (qmail 7135 invoked by uid 1001); 12 Jul 2001 00:39:30 -0000 Content-Type: text/plain; charset="iso-8859-1" From: Mars G Miro Reply-To: mars@cannoncreek.com To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: epoch to show millseconds Date: Thu, 12 Jul 2001 08:39:30 +0800 X-Mailer: KMail [version 1.2] Received: from the Dark Corners of Oblivion (172.16.1.254) X-Sender-Ip: 172.16.1.254 X-Copyright: 2001, Mars G. Miro, All Rights Reserved X-Notice: Redistribution and Duplication prohibited without proper consent of the Author MIME-Version: 1.0 Message-Id: <01071208393000.07133@hellraiser.cannoncreek.com> Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/212 X-Sequence-Number: 4008 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