X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 33F78475F16 for ; Fri, 2 May 2003 09:12:48 -0400 (EDT) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 8591D475E9D for ; Fri, 2 May 2003 09:12:40 -0400 (EDT) Received: (qmail 25754 invoked from network); 2 May 2003 13:13:35 -0000 Received: from unknown (HELO system67.trade-india-local.com) (unknown) by unknown with SMTP; 2 May 2003 13:13:35 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: pgsql-sql@postgresql.org Subject: timeofday() and now() issue.. Date: Fri, 2 May 2003 18:44:35 +0530 User-Agent: KMail/1.5 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200305021844.35194.mallah@trade-india.com> X-Spam-Status: No, hits=-7.2 required=5.0 tests=BAYES_01,SIGNATURE_SHORT_SPARSE,USER_AGENT version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/20 X-Sequence-Number: 13185 SELECT CAST (timeofday() as timestamp with time zone) - CAST (now() as timestamp with time zone); +-----------------+ | ?column? | +-----------------+ | 03:30:00.000295 | +-----------------+ shudn't it return something close to 0 ? like SELECT CAST (timeofday() as timestamp ) - CAST (now() as timestamp with time zone); +-----------------+ | ?column? | +-----------------+ | 00:00:00.000405 | +-----------------+ regds Mallah -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.