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

[Morbus I. <mo...@di...>]

> That would seem to fit within your thinking.  I still wonder if it would 
> better to add a third option for the point that would allow indication 
> of "March 12, 14, 19".

Well, it can - the actual PHP code will handle this transparently, such 
that someone entering "1999" for a date would automatically have that 
put into date_raw, and 1999-01-01 and 1999-12-31 in date_start and 
date_end respectively. Likewise, a date entered of "1999-04" would have 
that stored in date_raw, 1999-04-01 in date_start, and 1999-04-31 in 
date_end. The goal here is to utilize the database's ability to handle 
dates, but also keep the user's original raw string around.

-- 
Morbus Iff ( that's crazier than a sack of ferrets at a hoe-down )
Technical: http://www.oreillynet.com/pub/au/779
Culture: http://www.disobey.com/ and http://www.gamegrene.com/
icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus