Re: inverse of "day of year"

When grilled further on (Fri, 19 Mar 2004 09:06:17 -0300),
Martin Marques <martin@bugs.unl.edu.ar> confessed:

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

Something like:

select date_trunc( 'year', now() ) + (extract( doy from now() ) - 1) *
'1day'::interval;

Later,
Rob

-- 06:46:54 up 8 days,  9:58,  2 users,  load average: 2.00, 2.11, 2.09
Linux 2.4.21-0.13_test #60 SMP Sun Dec 7 17:00:02 MST 2003