Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 089A09F946B for ; Thu, 16 Nov 2006 18:29:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 70828-10 for ; Thu, 16 Nov 2006 18:29:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vms042pub.verizon.net (vms042pub.verizon.net [206.46.252.42]) by postgresql.org (Postfix) with ESMTP id 1CC779F946A for ; Thu, 16 Nov 2006 18:29:08 -0400 (AST) Received: from [192.168.7.5] ([71.101.10.99]) by vms042.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0J8U009EGGTU4ED2@vms042.mailsrvcs.net> for pgsql-sql@postgresql.org; Thu, 16 Nov 2006 16:22:43 -0600 (CST) Date: Thu, 16 Nov 2006 17:23:44 -0500 From: Joe Subject: Re: Question about time In-reply-to: <455C8E4F.5060406@correolux.com.mx> To: Judith Cc: pgsql-sql@postgresql.org Message-id: <1163715824.692.1.camel@pampa> Organization: Freedom Circle, LLC MIME-version: 1.0 X-Mailer: Evolution 2.8.1.1 FreeBSD GNOME Team Port Content-type: text/plain Content-transfer-encoding: 7bit References: <455C8E4F.5060406@correolux.com.mx> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/178 X-Sequence-Number: 26830 On Thu, 2006-11-16 at 10:14 -0600, Judith wrote: > Hi everyone I'm doing a query like this: > > SELECT CAST(fecha_hora_factura as time) FROM nota_venta > > and I get: > > 14:16:52.824395 > > the field is timestamp type....... I just want the HOUR:MINUTE:SECOND > > the question is how I drop the millisecond?? Take a look at date_trunc() under Date/Time Functions and Operators. Joe