Re: [libdb-develop] [feature] Date Ranges and Database Manipulations

[Bruce D'A. <bd...@fa...>]

On Aug 18, 2004, at 6:42 PM, Morbus Iff wrote:

> Hmm. That's an interesting idea. What about:
>
>  date             (as it is - YYYY-MM-DD)
>  date_approximate (a string of any kind)
>
> The downside is that they'll probably be far more date_approximate's
> than date's, and that date processing would need to be handled in the
> code, not the database.

Question:

Would one typically store YYYY-MM as YYYY-MM-00?  In other words, the 
00 represents null, but is still valid with respect to datatyping for 
the db?

Bruce