On Sat, Sep 6, 2008 at 10:21 AM, brian <brian@zijn-digital.com> wrote:
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?
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.rkmr.em@gmail.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?
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?
No comments:
Post a Comment