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 3930AD1E93F for ; Fri, 19 Mar 2004 12:08:05 +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 64380-04 for ; Fri, 19 Mar 2004 08:08:05 -0400 (AST) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by svr1.postgresql.org (Postfix) with ESMTP id 36D4ED1E414 for ; Fri, 19 Mar 2004 08:08:02 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 0AF6511E3D for ; Fri, 19 Mar 2004 09:06:20 -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 06872-02 for ; Fri, 19 Mar 2004 09:06:19 -0300 (ART) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 5A32D11DF5 for ; Fri, 19 Mar 2004 09:06:19 -0300 (ART) From: Martin Marques To: pgsql-sql@postgresql.org Subject: inverse of "day of year" Date: Fri, 19 Mar 2004 09:06:17 -0300 User-Agent: KMail/1.5.4 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200403190906.17641.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/198 X-Sequence-Number: 17297 Is there a function that would give me the date for a given day of year? Something like the inverse of "EXTRACT(doy FROM date)"? --=20 09:04:02 up 10 days, 13:35, 4 users, load average: 0.42, 0.29, 0.33 ----------------------------------------------------------------- Mart=EDn Marqu=E9s | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral -----------------------------------------------------------------