X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 865F0329F3C for ; Sun, 3 Oct 2004 21:50:27 +0100 (BST) 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 54652-10 for ; Sun, 3 Oct 2004 20:50:16 +0000 (GMT) Received: from mailserver.bolig.net (cpe.atm2-0-7982.0x535ae2ea.hknxx2.customer.tele.dk [83.90.226.234]) by svr1.postgresql.org (Postfix) with ESMTP id E32BC329F31 for ; Sun, 3 Oct 2004 21:50:17 +0100 (BST) Received: by mailserver.bolig.net (Postfix, from userid 65534) id AD31B11ECC; Sun, 3 Oct 2004 22:50:16 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by mailserver.bolig.net (Postfix) with ESMTP id BC06D11ED9 for ; Sun, 3 Oct 2004 22:50:15 +0200 (CEST) Received: from [192.168.1.102] (cpe.atm2-0-7982.0x535ae2ea.hknxx2.customer.tele.dk [83.90.226.234]) by mailserver.bolig.net (Postfix) with ESMTP id D5B4611ECA for ; Sun, 3 Oct 2004 22:50:13 +0200 (CEST) Message-ID: <41606605.9040704@cuatro.dk> Date: Sun, 03 Oct 2004 22:50:13 +0200 From: Jens Arnfelt User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: How to convert 3 colums to timestamp with timezone Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/16 X-Sequence-Number: 19119 Hi There! Hope this is an easy one :-D How do I convert 3 individuel colums with type "date", "time" and "integer" to at timestamp with timexone? eg. tabel cStartUnixtime cStartTime cStartZone 09-24-2004 10:27:12 -2 This I have to present as an timestamp with timezone. Thanks in advance Jens Arnfelt