Re: Storing a "fuzzy date"

As far as I could see from the thread the dates always are used like an interval.

So you store the "from" meaning and the "to" meaning.

Example: "Feb 20th 2002" -> "from 2002/02/20 00:00:00" "to 2002/02/20 23:59:59" "Feb 2002" -> "from 2002/02/01 00:00:00" "to 2002/02/28 23:59:59" "2002" -> "from 2002/01/01 00:00:00" "to 2002/12/31 23:59:59"

Martin

"Michael G. Schneider" wrote:
>
> With Oracle 8.1.7
>
> In my application I would like to support a "fuzzy date". The database
> should not only hold specific dates (as e.g. Feb 20th 2002), but also
> month/year-based dates as "Feb 2002" or just "2002".
>
> Any suggestions on how this might be done, without loosing the
> DATE-functionality too much.
>
> Michael G. Schneider
Received on Tue Mar 05 2002 - 01:39:51 CST