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 ----------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster