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?