I was cleaning up my codebase the other day and noticed that more than a few people recommend indexing on ttoc() when a datetime field is concerned, instead of directly indexing on the column.

I never ran into any problems with indexing on the datetime type, but I am curious why "everyone" assumes its a no-no.

Thanks.