On Sat, Sep 6, 2008 at 10:21 AM, brian <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] 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?