X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6826D475EFD for ; Fri, 4 Apr 2003 17:01:36 -0500 (EST) Received: from bast.unixathome.org (bast.unixathome.org [66.11.174.150]) by postgresql.org (Postfix) with ESMTP id 9CE40475C3D for ; Fri, 4 Apr 2003 17:01:31 -0500 (EST) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id 9C7453D28; Fri, 4 Apr 2003 17:01:32 -0500 (EST) From: "Dan Langille" To: Claude Date: Fri, 04 Apr 2003 17:01:32 -0500 MIME-Version: 1.0 Subject: Re: timestamp with postgresql 7.3 Cc: pgsql-sql@postgresql.org Message-ID: <3E8DBA6C.14055.194601A0@localhost> In-reply-to: X-mailer: Pegasus Mail for Windows (v4.02a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Spam-Status: No, hits=-25.8 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, QUOTE_TWICE_1,REPLY_WITH_QUOTES 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/72 X-Sequence-Number: 12773 On 4 Apr 2003 at 22:18, Claude wrote: > > 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? I think you need to read the 7.3 documentation and release notes. -- Dan Langille : http://www.langille.org/