Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 245A02E2D8C for ; Wed, 12 Mar 2008 19:43:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 03200-04 for ; Wed, 12 Mar 2008 19:43:04 -0300 (ADT) X-Greylist: delayed 00:06:29.963209 by SQLgrey-1.7.5 Received: from message.trenix.com.br (201-0-136-221.dial-up.telesp.net.br [201.0.136.221]) by postgresql.org (Postfix) with ESMTP id 809882E2D82 for ; Wed, 12 Mar 2008 19:43:10 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by message.trenix.com.br (Postfix) with ESMTP id 45FCC504063 for ; Wed, 12 Mar 2008 19:36:43 -0300 (BRT) X-Virus-Scanned: amavisd-new at trenix.com.br Received: from message.trenix.com.br ([127.0.0.1]) by localhost (message.trenix.com.br [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id UbajLbCGX7Jo for ; Wed, 12 Mar 2008 19:36:37 -0300 (BRT) Received: from gigastation.trenix.com.br (unknown [192.168.255.150]) (using TLSv1 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: douglas@trenix.com.br) by message.trenix.com.br (Postfix) with ESMTP id A7299504062 for ; Wed, 12 Mar 2008 19:36:37 -0300 (BRT) From: "Valter Douglas =?utf-8?q?Lisb=C3=B4a?= Jr." Organization: Trenix - IT Solutions To: pgsql-sql@postgresql.org Subject: Timestamp, epoch and a bit confusion Date: Wed, 12 Mar 2008 19:36:13 -0300 User-Agent: KMail/1.9.7 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200803121936.14106.douglas@trenix.com.br> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.224 tagged_above=0 required=5 tests=RCVD_IN_PBL=0.509, RCVD_IN_SORBS_DUL=1.615, RDNS_DYNAMIC=0.1 X-Spam-Level: ** X-Archive-Number: 200803/61 X-Sequence-Number: 30389 Hello all. I working with postgreSQL for a couple of months, and now I trying to conve= rt=20 timestamp columns in epoch and epoch to timestamp columns. So far I could=20 reach, all SQL I find by 'googling' returns an error. Where can I find some documentation with this convertions fo 8.2.x branch? = I=20 think the Manual on the main site is not very helpfull in this case!!! ;-( Thanks in advance. =2D-=20 Valter Douglas Lisb=C3=B4a Jr. S=C3=B3cio-Diretor Trenix - IT Solutions "Nossas Id=C3=A9ias, suas Solu=C3=A7=C3=B5es!" www.trenix.com.br contato@trenix.com.br Tel. +55 19 3402.2957 Cel. +55 19 9183.4244