It seems odd to me that the data type "Year", should only allow the limited range of 1901-2155. i understand that this is so that it will store in 1 byte, but whats the point? i wanted to use a year field for historical data, such as the year famous people were born, such as abe lincoln - 1809, but surprise surprise 1809 is unacceptable.
so i guess i dont see the point of the year datatype. i would be interented in any insight as to why the year type is like this. thanks, sean peters [EMAIL PROTECTED] mysql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php