X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4DB254758E6 for ; Fri, 4 Apr 2003 15:18:39 -0500 (EST) Received: from bar.noc.be.easynet.net (bar.noc.be.easynet.net [212.100.163.72]) by postgresql.org (Postfix) with ESMTP id AF2D2474E42 for ; Fri, 4 Apr 2003 15:18:38 -0500 (EST) Received: from claude (helo=localhost) by bar.noc.be.easynet.net with local-esmtp (Exim 3.36 #1 (Debian)) id 191Xe2-0006t7-00 for ; Fri, 04 Apr 2003 22:18:38 +0200 Date: Fri, 4 Apr 2003 22:18:38 +0200 (CEST) From: Claude X-X-Sender: claude@bar.noc.be.easynet.net To: pgsql-sql@postgresql.org Subject: timestamp with postgresql 7.3 Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=-12.3 required=5.0 tests=BAYES_01,USER_AGENT_PINE autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/71 X-Sequence-Number: 12772 Hi, I have a table a field with timestamps in seconds since epoch and I would like to get a human readable date... but it seems that postgresql 7.3 does not support the datetime(), timestamp(), timestamptz() functions... I tried the example in: http://archives.postgresql.org/pgsql-bugs/2002-07/msg00117.php and get: DB=# select val, datetime(val), "timestamp"(val), timestamptz(val) from test_table; ERROR: Function datetime(integer) does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts And tried various typecasts without any success. Any help? --- Claude