Re: storing repeating dates / events
| От | rkmr.em@gmail.com |
|---|---|
| Тема | Re: storing repeating dates / events |
| Дата | |
| Msg-id | e04d2e90809061033u5f606390q57069b6fb91c1f92@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: storing repeating dates / events (brian <brian@zijn-digital.com>) |
| Список | pgsql-general |
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?
В списке pgsql-general по дате отправления: