[libdb-develop] Dates In An RDBMS - Years Only?
Status: Inactive
Brought to you by:
morbus
From: Morbus I. <mo...@di...> - 2004-01-14 16:29:12
|
For purposes explained below: * all dates not related to a person or corporate body are years. * all dates related to a person or corporate body must be yyyy-mm-dd. In MySQL, at least, there's no "proper" way to represent a YYYY or YYYY-MM-DD in *one* column: we'd end up with stuff like "1999-00-00", which seems rather evil to me (or is it? let me know your thoughts.) -- Morbus Iff ( i put the demon back in codemonkey ) Culture: http://www.disobey.com/ and http://www.gamegrene.com/ Spidering Hacks: http://amazon.com/exec/obidos/ASIN/0596005776/disobeycom icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus |