Re: storing repeating dates / events

On Sat, Sep 6, 2008 at 10:21 AM, brian <brian(at)zijn-digital(dot)com> wrote:

> rkmr(dot)em(at)gmail(dot)com wrote:
>
>> Hi
>> I want to store dates / events for example birthdays (or may 5th) that
>> repeats every year..
>> what is the best way to do in postgres?
>> if i use timestamp it is going to be use the current year.. how do i do
>> this?
>>
> A timestamp includes the year so there shouldn't be any problem. Although,
> i can't say i'm sure what you think might be the problem. Perhaps you should
> clarify what it is you want to store, as well as your concerns.

if it includes the year, how do i query out and find birthdays for this
this year? like if i had a table with column

user text,
dob timestamp without timezone,

can you tell me what the query will be to find todays birthday?