Re: Date math

On Sun, Jun 28, 2009 at 2:52 PM, Joe Conway <mail(at)joeconway(dot)com> wrote:

> Adam Rich wrote:
>
>> Hello,
>> I have a table with a DATE field "birth_date". The data obviously
>> contains various dates in the past, such as 07/04/1970. In my query, I need
>> to retrieve the person's "next" birthday. In other words, for the example
>> date 07/04/1970, the query should return 07/04/2009 for the current week,
>> but after this July 4th, it would return 07/04/2010. Ultimately, I need to
>> find people with "next" birthdays within a certain range.
>>
>>
If all you want to do is check to see if someone's birthday is coming up
within a set period, then this query will return true or false:

SELECT extract(doy FROM TIMESTAMP '1970-07-20')
BETWEEN
extract(doy FROM now()) AND
extract( doy FROM CURRENT_DATE +30)

Guy Flaherty

[]
[]