Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group