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 398FCD9599 for ; Thu, 10 Nov 2005 14:03:45 -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 29132-10 for ; Thu, 10 Nov 2005 18:03:43 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from CORREO.correolux.com.mx (customer-200-79-53-218.uninet-ide.com.mx [200.79.53.218]) by svr1.postgresql.org (Postfix) with ESMTP id CE631D7CB7 for ; Thu, 10 Nov 2005 14:03:41 -0400 (AST) Received: from 192.168.7.58 ([192.168.7.58]) by correolux.com.mx with MailEnable ESMTP; Thu, 10 Nov 2005 09:04:46 -0600 Subject: time From: Judith Altamirano Figueroa To: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary="=-xHZwlhZA25iMLbh3E7GN" Date: Thu, 10 Nov 2005 09:03:55 -0600 Message-Id: <1131635035.3529.143.camel@Desarrollo> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.026 required=5 tests=[AWL=0.025, HTML_MESSAGE=0.001] X-Spam-Score: 0.026 X-Spam-Level: X-Archive-Number: 200511/90 X-Sequence-Number: 23341 --=-xHZwlhZA25iMLbh3E7GN Content-Type: text/plain Content-Transfer-Encoding: 7bit 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!!!!!!! --=-xHZwlhZA25iMLbh3E7GN Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit 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!!!!!!! --=-xHZwlhZA25iMLbh3E7GN--