According to Chapter 6 of the MySQL Reference Manual, ISBN 0-596-00265-3, Page 453 Year values 00-69 are the years 2000-2069 Year values 70-99 are the years 1970-1999
A date value would have to be based on the size of a UNIX date long integer, the number of seconds since 12:00AM, January 1, 1970 Try create a test table with just one column, a DATETIME, populate it with a year's worth of seconds. Then two years, then four years. Just examine the size of the .MYI file of the test table with each iteration. ----- Original Message ----- From: Alec Matusis <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Thursday, November 9, 2006 4:17:43 PM GMT-0500 US/Eastern Subject: How to determine index size ? What is the byte size of an index for datetime type column? How can I compute disk space required if I want to add an index on a DATETIME column? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]