Dates with unknown month and/or day - Mailing list pgsql-novice

From Sean Davis
Subject Dates with unknown month and/or day
Date
Msg-id 472F34BE.3070606@mail.nih.gov
Whole thread Raw
List 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 by date:

Previous
From: John DeSoi
Date:
Subject: Re: Uncertain about recoding prepared statements from MySQL to PostgreSQL
Next
From: Sean Davis
Date:
Subject: Re: Dates with unknown month and/or day