On Mon, 27 Oct 2003 18:34:34 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 5:32 PM -0500 10/27/03, sean peters wrote:Hi all, I have run into a date storage problem that i don't like. A am storing historic house sales, and some of the old data i have received only contains the month and year, but not the date of the sale. Of course we want to store this information, but a DATE column won't quite do the job, because year, month, and day are all required.
No, they're not. Use '00' for the missing parts, e..g., '1970-03-00' or '1948-00-00'.
For future reference, does this effect order by clauses in the way one would expect? (ie., 00 precedes 01). The docs make it seem as though use of invalid dates results in undefined behavior.
Can you indicate which part of the docs you're referring to? Thanks.
-bluejack
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
