Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id 86AE49F946A for ; Thu, 16 Nov 2006 18:12:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 14828-06 for ; Thu, 16 Nov 2006 18:12:04 -0400 (AST) X-Greylist: delayed 02:59:57.835928 by SQLgrey- Received: from CORREO.correolux.com.mx (customer-200-79-53-218.uninet-ide.com.mx [200.79.53.218]) by postgresql.org (Postfix) with ESMTP id 313B09F946B for ; Thu, 16 Nov 2006 18:12:18 -0400 (AST) Received: from [192.168.7.58] ([192.168.7.58]) by correolux.com.mx with MailEnable ESMTP; Thu, 16 Nov 2006 10:17:17 -0600 Message-ID: <455C8E4F.5060406@correolux.com.mx> Date: Thu, 16 Nov 2006 10:14:07 -0600 From: Judith User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: es-es, es MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Question about time Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200611/176 X-Sequence-Number: 26828 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?? Thnx in advanced!!!