X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6D435D1EAF8 for ; Tue, 23 Mar 2004 14:06:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 69557-02 for ; Tue, 23 Mar 2004 10:06:37 -0400 (AST) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by svr1.postgresql.org (Postfix) with ESMTP id 4A96ED1E9C2 for ; Tue, 23 Mar 2004 10:06:33 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 804C111E39; Tue, 23 Mar 2004 11:04:14 -0300 (ART) Received: from bugs.unl.edu.ar ([127.0.0.1]) by localhost (bugs [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21829-06; Tue, 23 Mar 2004 11:04:14 -0300 (ART) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 2362011DE9; Tue, 23 Mar 2004 11:04:14 -0300 (ART) From: Martin Marques To: Dana Hudes , pgsql-sql@postgresql.org Subject: Re: inverse of "day of year" Date: Tue, 23 Mar 2004 11:04:12 -0300 User-Agent: KMail/1.5.4 References: <200403190906.17641.martin@bugs.unl.edu.ar> <20040322151810.GB2962@wolff.to> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200403231104.12552.martin@bugs.unl.edu.ar> X-Virus-Scanned: by amavisd-new-20030616-p7 (Debian) at unl.edu.ar X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/232 X-Sequence-Number: 17331 El Lun 22 Mar 2004 12:56, Dana Hudes escribi=F3: > If you have the option to handle the date manipulation in Perl > use the DateTime modules. Also see Date::Calc. NO! Actualy what I'm doing is getting out of that (I'm using PHP's PEAR=20 Date::Calc) by creating some nice SQL and PL/PgSQL functions in the DB=20 server. --=20 11:01:02 up 14 days, 15:32, 4 users, load average: 1.48, 1.11, 0.72 ----------------------------------------------------------------- Mart=EDn Marqu=E9s | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral -----------------------------------------------------------------