Dates with unknown month and/or day

Поиск
Список
Период
Сортировка
От Sean Davis
Тема Dates with unknown month and/or day
Дата
Msg-id 472F34BE.3070606@mail.nih.gov
обсуждение исходный текст
Список pgsql-novice
What is the best way to treat dates with unknown month and/or day?  I
have some historical data that has only year or year/month, while the
newest data has year/month/day.  If there is no other option than to set
unknowns to '1', that will work, but I wanted to make sure that there
was not another way (and I can't see how there could be given the way
that date functions work).

Thanks,
Sean

В списке pgsql-novice по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: Uncertain about recoding prepared statements from MySQL to PostgreSQL
Следующее
От: Sean Davis
Дата:
Сообщение: Re: Dates with unknown month and/or day