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 17BE3D9599 for ; Thu, 10 Nov 2005 14:11:29 -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 69420-02 for ; Thu, 10 Nov 2005 18:11:27 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from keymaster.look.ca (delta1.look.ca [207.136.80.9]) by svr1.postgresql.org (Postfix) with ESMTP id A79E2D7BF7 for ; Thu, 10 Nov 2005 14:11:27 -0400 (AST) Received: from 216-154-14-245.dsl.look.ca ([216.154.14.245]) by keymaster.look.ca with esmtp (Exim 4.20) id 1EaGtT-0002oY-Ez; Thu, 10 Nov 2005 18:11:27 +0000 From: Rod Taylor To: Judith Altamirano Figueroa Cc: pgsql-sql@postgresql.org In-Reply-To: <1131635035.3529.143.camel@Desarrollo> References: <1131635035.3529.143.camel@Desarrollo> Date: Thu, 10 Nov 2005 13:11:27 -0500 Message-Id: <1131646287.819.144.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.011 required=5 tests=[AWL=0.011] X-Spam-Score: 0.011 X-Spam-Level: X-Archive-Number: 200511/91 X-Sequence-Number: 23342 On Thu, 2005-11-10 at 09:03 -0600, Judith Altamirano Figueroa wrote: > Hello everybody!!!, I'd like to know if there another way to get the > time from a timestamp type, because in earliest versions I just get > the time like time(fecha) and now this returns an error, thanks in > advanced!!!!!!! rbt=# select cast(now() - date_trunc('day', now()) as time); time ----------------- 13:10:42.495579 (1 row) --