When grilled further on (Fri, 19 Mar 2004 09:06:17 -0300), Martin Marques <[EMAIL PROTECTED]> 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
pgp00000.pgp
Description: PGP signature
