Postgres Pro
Downloads
Home   >   mailing lists

inverse of "day of year" - Mailing list pgsql-sql

From Martin Marques
Subject inverse of "day of year"
Date
Msg-id 200403190906.17641.martin@bugs.unl.edu.ar
Whole thread Raw
Responses Re: inverse of "day of year"
List pgsql-sql
Tree view 
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
-----------------------------------------------------------------

pgsql-sql by date:

Previous
From: Adam Ruth
Date:
Subject: Re: perfomance question
Next
From: "Kumar"
Date:
Subject: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls