inverse of "day of year"

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: pgsql-sql(at)postgresql(dot)org
Subject: inverse of "day of year"
Date: 2004-03-19 12:06:17
Message-ID: 200403190906.17641.martin@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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)"?

--
09:04:02 up 10 days, 13:35, 4 users, load average: 0.42, 0.29, 0.33
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kumar 2004-03-19 12:39:33 psql: FATAL 1: IDENT authentication failed for user error - Urgent pls
Previous Message Adam Ruth 2004-03-19 07:14:29 Re: perfomance question