How do I add an index to a column that is datetime?

Question

Possible Duplicate
How does one create an index on the date part of DATETIME field in MySql

In mysql. It's a date column

Answer 1

You do it in the same way as you would for any other column type:

CREATE INDEX IX_tblname_columnname
ON tbl_name (columnname)

See the documentation for more information and other options.