Can I create a index on a column of Type datetime?

[wangxu]

I will very often do query like this:

select * from mytable where create_date >='...' and create_date <='....'

can I create a index on the column create_date?

what is the best practise?

Thanks,
shell.