Re: Storing a "fuzzy date"

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 21 Feb 2002 18:32:58 GMT
Message-ID: <3C753D6F.88820B8F@ci.seattle.wa.us>

How about function based indexes?

Daniel Morgan

"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 Thu Feb 21 2002 - 12:32:58 CST