>DTOC() is actually dependent on the current SET DATE setting, so it's a very risky choice for indexes. For a date field, as you say, DTOS() is the way to go. For datetime, as others said, TTOC(,1).

It's not entirely correct because DTOC(,1) is the same as DTOS().