X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B736E475A71 for ; Tue, 25 Mar 2003 09:38:37 -0500 (EST) Received: from smtp.convergia.net (unknown [66.201.240.182]) by postgresql.org (Postfix) with ESMTP id 4C3CC474E44 for ; Tue, 25 Mar 2003 09:38:37 -0500 (EST) Received: from converdev01 (unknown [172.28.7.230]) by smtp.convergia.net (Postfix) with SMTP id 23E6C1C807D for ; Tue, 25 Mar 2003 09:38:41 -0500 (EST) Reply-To: From: "Liang Luo" To: Subject: How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ? Date: Tue, 25 Mar 2003 09:38:40 -0500 Message-ID: <00e401c2f2dc$3aa87280$e6071cac@convergia.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 Importance: Normal X-Spam-Status: No, hits=0.0 required=5.0 tests=none version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/560 X-Sequence-Number: 12598 This is the query and result: select h323_setup_time from pv_legs_new where h323_setup_time = '2003-01-01 00:43:59.996-05'; h323_setup_time --------------------------- 2003-01-01 00:43:60.00-05 Actually, the real data of second and millisecond is 59.996-05, but it shows 60.00. I failed to load it when I use this result in other query.