X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 68177D9CDC for ; Thu, 10 Nov 2005 14:27:15 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74843-06 for ; Thu, 10 Nov 2005 18:27:13 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from jandor.look.ca (theta1.look.ca [207.136.80.122]) by svr1.postgresql.org (Postfix) with ESMTP id BA795D9599 for ; Thu, 10 Nov 2005 14:27:13 -0400 (AST) Received: from 216-154-14-245.dsl.look.ca ([216.154.14.245]) by jandor.look.ca with esmtp (Exim 4.20) id 1EaH8g-000528-Lc; Thu, 10 Nov 2005 18:27:10 +0000 From: Rod Taylor To: Michael Fuhr Cc: Judith Altamirano Figueroa , pgsql-sql@postgresql.org In-Reply-To: <20051110182139.GA87715@winnie.fuhr.org> References: <1131635035.3529.143.camel@Desarrollo> <1131646287.819.144.camel@home> <20051110182139.GA87715@winnie.fuhr.org> Date: Thu, 10 Nov 2005 13:27:10 -0500 Message-Id: <1131647230.819.147.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 FreeBSD GNOME Team Port X-SA-Exim-Mail-From: pg@rbt.ca Subject: Re: time Content-Type: text/plain Content-Transfer-Encoding: 7bit X-SA-Exim-Version: 3.1 (built Tue Feb 24 05:09:27 GMT 2004) X-SA-Exim-Scanned: Yes X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.01 required=5 tests=[AWL=0.010] X-Spam-Score: 0.01 X-Spam-Level: X-Archive-Number: 200511/93 X-Sequence-Number: 23344 On Thu, 2005-11-10 at 11:21 -0700, Michael Fuhr wrote: > On Thu, Nov 10, 2005 at 01:11:27PM -0500, Rod Taylor wrote: > > rbt=# select cast(now() - date_trunc('day', now()) as time); > > time > > ----------------- > > 13:10:42.495579 > > (1 row) > > Am I missing something? Is there a reason not to simply cast the > timestamp value to time? Nope. I had thought that the question came up because a straight cast didn't work so I gave the first work around I thought of. --